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...

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.

Thank you Vaughan, I really appreciate your advice.