add 2years

[adhhealth]

I print "printdate" on my report and I have to print another date which should be "printdate" + 2years. How can we do this?

 

[lisanguyen]

Hi,

You can use the dateadd function
DateAdd("yyyy", 1, printdate)

 

[bdreed35]

Create a new formula field.

In the formula field, use the formula that lisa posted above, except use a 2 instead of a 1.

DateAdd("yyyy", 2, printdate)

I assume that was just a typo on her part. You get more info on the DateAdd function in the help files.

~Brian