This content has been marked as final. Show 3 replies
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?