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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.

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