Adding Years to a Date

[Guest]

Hi,

I wanted to add two years to a date column.
Example:
07/01/06 = 07/01/08

Does anyone know how to do this?

 

[Guest]

Hi.

Use the DateAdd function:

DateAdd("yyyy",2,[DateField])

-Michael

 

[Paul Overway]

NewDate = DateSerial(Year(OldDate)+2,Month(OldDate),Day(OldDate))

 

[Rick Brandt]

Hi,

I wanted to add two years to a date column.
Example:
07/01/06 = 07/01/08

Does anyone know how to do this?

There is a DateAdd() function.

DateAdd("yyyy", 2, [YourDateField])

 

[Guest]

Thanks Mike.

I just had finished reading the previous post when you responded.

Thank You very much

Hi.

Use the DateAdd function:

DateAdd("yyyy",2,[DateField])

-Michael

Hi,

I wanted to add two years to a date column.
Example:
07/01/06 = 07/01/08

Does anyone know how to do this?