Get Next Month?

[Matthew R White]

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

Month (Get (CurrentDate) + 1 

 

Not working

[LaRetta]

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

[comment]

Not working

 

Please be more specific than that.

[Rick Whitelaw]

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"

[LaRetta]

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!!  :-)

[Rick Whitelaw]

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.