i have date field(1st Field) and i am trying to add another field that calculates 1 year from first field. for example,
1st Field (Date Field)
2nd Field (Formula Date Field) ( this field should show 1 year from 1st field)
i tried all i knew but didnt work.
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.
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.
NealPatil @ gmx.com