AnsweredAssumed Answered

Calculating month name for two months ahead

Question asked by mbarrett65 on Dec 15, 2018
Latest reply on Dec 29, 2018 by TobiasLiebhartKoschierSE

I am trying to write a calculation that will give me the monthName two months ahead of the current date. This let statement is not working and always returns "January."

 

Let (

[

CurrentDate = Get (CurrentDate);

CurrentMonth = Month (CurrentDate);

TwoMonthsAhead = Case ( CurrentMonth = 11; 1;CurrentMonth = 12; 2; CurrentMonth+2)

]

;

MonthName(TwoMonthsAhead)

 

)

 

Any suggestions? Thank you.

Outcomes