calculating dates with date formula.

Try this

AdjustYear([My date field],1)

Here is the help on that https://www.quickbase.com/db/6ewwzuuj?a=dr&rid=35&rl=dm7

It deals with Leap years too.

You can create a new date-formula field with following type of date-formula for adding one year to the given date.
AdjustYear([dt1], +1)

In the above example dt1 is a name of the  date field.

Replace "dt1" with proper date-field-name to which you are adding one year.

Neal

NealPatil @ gmx.com

What is the formula if you are adding just a day, a week or a month?

to add a day it would be

[my date field] + Days(1)

To adjust the month it would be

AdjustMonth([my date field],3) to move three months ahead.

Thank you.