AnsweredAssumed Answered

Weird Date Calc Result

Question asked by dale_allyn on Aug 22, 2017
Latest reply on Aug 22, 2017 by dale_allyn

I have a "membership" option where clients may opt to buy a membership (for various benefits). Membership duration options are 1, 2 or 5 years.

 

Strangely, in a calculated field (Membership Expiration Date), FM calculates correctly if I use "-2" for the final calc of expiration date, but does not for "-1". In other words, joining on 7/1/2017 as a one year member, membership should expire 6/30/2017 with:

 

Date (

  Month ( memberStartDate ) ;

  Day ( memberStartDate ) ;

  Year ( memberStartDate ) + 1

) -1

 

But the result is: 7/1/2018.

 

So the "-1" is ignored.

 

If I use the calculation:

 

Date (

  Month ( memberStartDate ) ;

  Day ( memberStartDate ) ;

  Year ( memberStartDate ) + 1

) -2

 

The result is: 6/29/2018

 

So the "-2" is respected and calculated, however, the client loses a day of membership.

 

Is this a bug, or am I missing something(s)?

Outcomes