AnsweredAssumed Answered

A month from today?

Question asked by disabled_morkus on Jan 5, 2016
Latest reply on Jan 12, 2016 by disabled_morkus

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,

 

- m

Outcomes