How do you do date calculations is FMP 7?

[surfer]

Hello-

I have 2 fields: "Age" and "DOB"

Can you please suggest a way to enter a person's age (via calculation,script)into the "Age" field once their Date of Birth is entered in "DOB"?

Also, is there a way to calculate what the date would be 30 days after a given date?

Thank you...

[Vaughan]

To calculate age, search the forums for "birthday" it has been discussed recently.

To add onto dates, use the Date (month, day, year) function.

For instance, to add 30 days to a field called "Joined" you'd use:

Date ( Month(Joined), Day(Joined)+30, Year(Joined) )

To add one month:

Date ( Month(Joined)+1, Day(Joined), Year(Joined) )

To add one year:

Date ( Month(Joined), Day(Joined), Year(Joined)+1 )

Just be very clear what you want to do when manipulating dates: there is a difference between adding 30 days and adding one month. Similarly, 90 days is not 3 months and 365 days is not one year.

Just to be complete: if you're simply adding a number of days to a date you can use the simplified expression

Date + <number of days>

But like I said, 30 days is not the same as one month.

[surfer]

Thank you Vaughan, I really appreciate your advice.