Adding Years to a Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Jose said:
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?
Click to expand...

There is a DateAdd() function.

DateAdd("yyyy", 2, [YourDateField])
 
Thanks Mike.

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

Thank You very much

Michael H said:
Hi.

Use the DateAdd function:

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

-Michael



Jose Aleman said:
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?
Click to expand...
Click to expand...
 
Back
Top