Date generation

[Jyuen204]

Apologies for the rather simplistic question. But I have a date set I generate in the code to reference.

REPORTDATE = intnx('Week',today(),-1,'E');

CW_END          = intnx('Week',ReportDate,0,'E');

This gives me the most recent Saturday that passed for a report I generate. I need to be able to get this exact Date in the previous year. So in this case March 7 2020 is the date generated from above code. I need to get March 7 2019. I would use a hard coded calculation but that would mess up in Leap years like this year.

Thanks in advance!

[PaigeMiller · Accepted solution]

oneyearago=intnx('year',cw_end,-1,'s');

[Jyuen204]

Thanks so much!

[Reeza]

The last parameter in the INTNX function is the alignment parameter. The option you're looking for is 'same' which will move it to the same date. Verify it treats leap years the way you want and you're good to go. You can also extract the month day and increment the year and use MDY() BUT that won't work for leap years so INTNX() is safer.