AnsweredAssumed Answered

Find name of next month

Question asked by skingjack on Jan 20, 2018
Latest reply on Feb 2, 2018 by skingjack

Calculations & dates do not mix well with me... =)

 

Date question ... if I was wanting to determine the name of the month following

a current date, what would need to be done. I'm able to extract the month name

of a field ( due date for example) with this calc:

 

((MonthName (Month(Due Date)))

 

If due date is = January 30/2018, above calc correctly returns "January".

 

How to get it return February? I've tried adding  +1  in various calc locations similiar

to below with no success.

 

(MonthName (Month(Due Date)+1))  * does not work

 

I'm stymied.

 

TIA.

Jack.

Outcomes