topic max date from last year in App Development

max date from last year

hamza99a — Wed, 18 Jul 2018 18:41:05 GMT

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!

Re: max date from last year

MarioCenteno — Wed, 18 Jul 2018 18:53:11 GMT

Try

Declare script

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

Re: max date from last year

hamza99a — Wed, 18 Jul 2018 19:45:55 GMT

that did not work but thanks for the response