Return to FileMaker.com
Populate field with next month
I need to populate a field with the next month ie if its currently October, the value must be November.
I thought this would work, but it doesn't
Set Field [Apartments::Month; MonthName(Get(CurrentDate) + 1)]
Get(CurrentDate) + 1
calculates the date for tomorrow, not next month.
Let ( T = Get ( CurrentDate ) ; MonthName ( Date ( Month ( T ) + 1 ; 1; Year ( T ) ) )
Retrieving data ...