Is there an intelligent way to have FileMaker tell me what one month from today is?
If the $renewDate is 1/31/16 and I issue this FMP command:
Date( Month ($renewDate) +1 ; Day($renewDate ) ; Year ($renewDate ) )
FM gives me: 3/2/16.
Not what I want.
I really want: Date( Month($renewDate + 1) ; ; ) to be 2/28/16, but this syntax does not work.
I did a workaround to get the right answer, but the basic issue is I don't know the function, if FM has one, that will just add one month to the current date.
In other environments, this calculation would be 2/28/16, which IS what I want, not 3/2/16.
Maybe I'm missing a FM function???
Thanks in advance,