topic Re: Store Today(1) into a variable in QlikView

Store Today(1) into a variable

arnoqlik — Thu, 12 Aug 2021 15:16:23 GMT

Hello,

At first I need to set the last day of the previous month:

LET vTODAY = Date(monthsstart(1, today(1))-1,'DD/MM/YYYY');

Then I need to remove one month if we are in January else keep the month as it is:

LET vYearFile = If(Num(Month($(vTODAY))) = 1, AddYears($(vTODAY), -1), Year($(vTODAY)));

I get 1899...

What's wrong with this code? Thank you guys!

stevejoyce — Thu, 12 Aug 2021 15:38:10 GMT

LET vYearFile = If(Num(Month($(#vTODAY))) = 1, Year(AddYears($(#vTODAY), -1)), Year($(#vTODAY)));

MayilVahanan — Fri, 13 Aug 2021 02:25:17 GMT

Try like below

LET vTODAY = Date(monthsstart(1, today(1))-1,'DD/MM/YYYY');
LET vYearFile = If(Num(Month(vTODAY)) = 1, AddYears(vTODAY, -1), Year(vTODAY));

vYearFile gives 2021

arnoqlik — Fri, 13 Aug 2021 09:17:04 GMT

Thanks, both solutions are working fine.