Date calculation based on variable

[Heathbo]

How do you modify a date fields month, without modifying the day and year. For example, I have two fields. One with a 9/12/2007 in it. The other field is a numeric field. I want whatever number you type in the numeric field to increase or decrease the month of the date in the date field.

[Vaughan]

Use the Date() function with the Day(), Month() and Year() functions to disassemble then reassemble the date.

Date( Month( date ) + number ; Day( date ) ; Year( date ) )

But please note that adding two months onto December 31 will not result in February 31; FMP will resolve the extra days into a date that makes sense, like March 3.

[Heathbo]

Your the man! Thanks, it works perfectly.