Store compared date in variable

[victor_greffet]

Hi Community,

I am beginner in Qlik development.

In my app I loaded different database (Excel files),

I get the full date of my four Excel files by using the FileTime() function and i would like to store the most recent date of these four files in a variable called vFileTime.

LET var1 = FileTime(File1)

LET var2 = FileTime(File2)

LET var3 = FileTime(File3)

LET var4 = FileTime(File4)

Do you have an idea ?

Thank you,

Victor

[maxgro]

let vFileTime= RangeMax(var1, var2, var3, var4);

[victor_greffet]

Simple and efficient, thank you !

[maxgro]

Qlik Community Tip: Marking Replies as Correct or Helpful