How do I make the date selection automatic?

[josephinetedesc]

Hi All

at present I have this as for my data load

LET vDateMin = Num(MakeDate(2016,07,01));

LET vDateMax = Num(MakeDate(2017,02,01));

However my SQL says:

greater than (Current Timestamp -5 months) and less than (Current Timestamp + 2 months)

I want to automate the Qlikview document so that it does the same thing as the SQL.  At present I manually change the vDateMin and vDateMax at the end of every month.

Is there a way that I can make vDateMin and vDateMax automatically?

Thank you

Jo

[tamilarasu · Accepted solution]

Hi Jo,

LET vDateMin =Num(Monthstart(Addmonths(Today(),-5)));
LET vDateMax =Num(Monthstart(Addmonths(Today(),2)));

[josephinetedesc]

Thank you Tamil

Jo

[tamilarasu]

No problem Jo. Have a good day.