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?

Hi.

Use the DateAdd function:

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

-Michael



"Jose Aleman" wrote:

> 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?

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

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


"Jose Aleman" <(E-Mail Removed)> wrote in message
news:0D11341E-5072-48C1-BD95-(E-Mail Removed)...
> 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 Aleman wrote:
> 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])

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks Mike.

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

Thank You very much

"Michael H" wrote:

> Hi.
>
> Use the DateAdd function:
>
> DateAdd("yyyy",2,[DateField])
>
> -Michael
>
>
>
> "Jose Aleman" wrote:
>
> > 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?