Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza99a
Creator II
Creator II

max date from last year

Hello all,

I am using qlik sense scripting and what I am trying to do is to load in the last available date from last year. For example in my folder from which I am pulling the last data for the year 2017 is december 29. What I want to do is import this file. Also my files are stored in the folder as  " employee_20171229.csv "

Is there a function for finding this day and loading it in. Thank you!

2 Replies
MarioCenteno
Creator III
Creator III

Try

Declare script

let vPriorYearDate = '=date(addyears(max(Field_date),-1),' & chr(39) & 'DD MMM YYYY' & chr(39) & ')';

hamza99a
Creator II
Creator II
Author

that did not work but thanks for the response