Date Function

[Altamedic]

Hi There,

First off, I am new to FileMaker and am use to access and their functions and am supprised the similarities.

Now for my question. I am converting my database for a class registration. Part of the registration process needs a class date and expiry date. The expiry date of the certification in driven by the type of certification.

Ie) First Aid is good for 36 months & Fall Protection is good for 12 months from class date.

I have set up a table with the various classes and their validity period.

I am trying to calculate the date from the class date "Event Date" to add the respective number of months in the class table I have called that "# Months Valid"

I am having a propblem with the formula

Expiry Date =

Month ( Date (Month (Event Date) + 36 ; Day (Event Date) ; Year (Event Date)))

Can some one help me with what I am doing wrong... The test "Event Date" is 17/01/2008 and Expiry Date is calculated to be 01/01/0001

Any help would be great!

[comment]

You are calculating the month of the target date - which is a number, and returns 1 (January) in your example. When your result is converted to date, it returns the first day in Filemaker's calendar.

Try instead:

Date ( Month ( Event Date ) + 36 ; Day ( Event Date ) ; Year ( Event Date ) )