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."
CurrentDate = Get (CurrentDate);
CurrentMonth = Month (CurrentDate);
TwoMonthsAhead = Case ( CurrentMonth = 11; 1;CurrentMonth = 12; 2; CurrentMonth+2)
Any suggestions? Thank you.