Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Last date files modification

Colleagues, good day!

In load script i need to set variable, which include information about last date files modification.

I need to read date modification only for those files, which have names Test*.xlsx

if last modification date=today(), then variable vLastDate =0

if last modification date=today()-1, hen variable vLastDate = 1

if last modification date=today()-2, hen variable vLastDate = 2

...

Source directory in attached zip.

Thanks.

Labels (1)
1 Reply
Or
MVP
MVP

Have a look at this thread, which details approaches to getting information from files within a directory:

Get attributes from files | Qlik Community