Trying to calculate next month in a field with the following calculation

Month (Get (CurrentDate) + 1 

 

Not working

Try this ( calculation, unstored, NUMBER )

Let ( d = Get ( CurrentDate ) ;
Month ( Date ( Month ( d ) + 1 ; 1 ; Year ( d ) ) )
)

With dates, it helps to use real dates so they span the 12-month barrier easier.

Oh wait, you can cross the month barrier using Mod()

Mod ( Month ( Get ( CurrentDate ) )  ; 12 ) + 1

Not working

 

Please be more specific than that.

Trying to calculate next month in a field with the following calculation

Month (Get (CurrentDate) + 1 

 

Not working

You're missing the right parenthesis before "+1"

Nice spotting of it, Rick!  

 

Unfortunately it can still break if the month is December.  It will say it is month 13 which is why I just went ahead and created the alternatives.  It has caught me before!!  :-)

Nice spotting of it, Rick!  

 

Unfortunately it can still break if the month is December.  It will say it is month 13 which is why I just went ahead and created the alternatives.  It has caught me before!!  :-)

Yup.