Date modification

[merkaba22]

I am aware that FileMaker can modify dates, for example, fora date a year later:

(date + 365).

However, in the case of a month later:

(date + 30)

does not return the same day a month later.

Is there another way to calculate this requirement?

[Raybaudi]

If the starting DATE is: 01/30/2010

which must be the ending one ?

[merkaba22]

Thanks Daniele:

Good point, but if there is a calc where the starting DATE is:

01/27/2010

the result required would be:

02/27/2010

[comment]

And if starting date is 01/31/2010?

[Lee Smith]

Do you mean this?

Date ( Month ( AnyDate ) + 1 ; Day ( AnyDate ) ; Year ( AnyDate ) )

Lee

[merkaba22]

Thanks Lee -- you nailed it!

[LaRetta]

However, in the case of a month later: (date + 30)

does not return the same day a month later. Is there another way to calculate this requirement?

You are missing the point by Daniele (although his example didn't show it) and Michael (Comment):

If the start is 1/31/2010, one month later would be 2/31/2010 which FM would translate to 3/3/2010 (or 3/2 if a leap year). You must define the rules on how the calculation should handle the difference when the number of days in the result month is shorter than the number of days in the beginning date. Do you want the last day of the SAME month or do you want it to run into the next month by (up to) 3 days?

Edited March 9, 2010 by Guest

[merkaba22]

Thanks Loretta -- but I did get it, that; why I changed the day ...

Nonetheless, you did provide me he answer to my next question and I thank you for that!

[merkaba22]

The requirements for the calc is that if the start date is 1/31/2010,one month later should be 2/28/2010, or 2/29/2010 if it's a leap year.

[comment]

See:

http://fmforums.com/forum/showpost.php?post/217855/

[Vaughan]

Change the requirement to specify an explicit number of days.

There is a reason why some warranties are specified as 30 days or 60 days. It avoids all confusion and ambiguity.