Store Today(1) into a variable

[arnoqlik]

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 · Accepted solution]

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

[MayilVahanan]

Hi

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]

Thanks, both solutions are working fine.