date result calculation

[stevec]

Hi! using FileMaker 5. I need to figure out a simple "expiration date"

I have a DealDate field (xx/xx/xxxx date format), a TermsInMonths field (number format) and need a calculation that shows the date the terms expire.

For example, if the DealDate is 1/13/2003, and the Terms field is 18, the result should say 7/13/2004.

What's the simple way to do this? (I tend to overlook the obvious and make it way too complex! heh)

Thanks for any help!

[Lee Smith]

Hi stevec,

New Calculation Field if you don't have one already - Results = Date

Date( Month(YourDateField) + 18, Day(YourDateField), Year(YourDateField))

HTH

Lee

[stevec]

PERFECT.

I appreciate the help!

[Vaughan]

Use the TermsInMonths field in the calculation to make it more flexible...

Date( Month(YourDateField) + TermsInMonths, Day(YourDateField), Year(YourDateField))