Filter on Date

[qlikviewaf]

Hi Guys,

i have a date DD/MM/YYYY field - i would like to reload the table taking just the value of the previous 12 month.

How this can be done?

For example if i run it today i would get the data from 01/08/2017 till Today.

Thank you

[felipedl]

Hi Antonio,

Do the following (assuming the date field is a numeric date interpretation)

// this will get the 01/08/2017 based of today's date.
let vDate = Num(AddYears(MonthStart(Today()),-1));

Load *
From [Whatever]
where [Date Field]>=$(vDate);

Felipe.

[qlikviewaf]

the result is 01/07/2018 instead of 01/08/2018

let vPrevious12Month = Num(AddYears(MonthStart(Today()),-1));

[felipedl · Accepted solution]

Use AddMonths instead, like this:

let vDate = Num(AddMonths(MonthStart(Today()),-11)); 

[vishus913]

hi yes,

Felip is right

add months would do the job

[felipedl]

Glad it helped .