max date from last year

[hamza99a]

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!

[MarioCenteno]

Try

Declare script

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

[hamza99a]

that did not work but thanks for the response