topic Max + FileTime. How to get the latest modified file? in QlikView

Max + FileTime. How to get the latest modified file?

Thu, 11 Jun 2015 20:39:32 GMT

Hello the community,

I have a folder with hundreds of .xlsx spreadsheets inside.

And a folder of QVDs.

If one spreadsheets has a modified time or date > than the create time of the QVDs, I'd like to re upload everything.

Now my pbm is: How do I tell qlikview to look for the latest updated spreadsheet?

I thought about combining MAX(FileTime ... ) but it doesn't work.

See below my script.

IF (alt(MAX(FileTime('$(RootDir_FACT)my_file.qvd') < Max(FileTime('$(RootDir_Data)myFile.xlsx'))))) THEN

Do you have any idea?

Thanks

Re: Max + FileTime. How to get the latest modified file?

maxgro — Thu, 11 Jun 2015 20:46:18 GMT

try here (Taras, Peter) to get the most recent file in a dir

Load last file

Re: Max + FileTime. How to get the latest modified file?

Thu, 11 Jun 2015 21:16:36 GMT

Thank you Massimo,

Actually I don't need to get those files, I really just need to tell qlikview to "do this if this situation happens", that is why Max(FileTime sounded good.

I'm gonna keep digging...