Subtract Two Years From Current Date

[ahd2008]

Hi everybody,

I want to create a code that subtract two years from the current date and returns the data.

For instance

Current date= 05/05/2009
Date before two years=current date-(2 years)
Date before two years=MM/DD/YYYY

Appreciate your cooperation

[JustJim]

Hi everybody,

I want to create a code that subtract two years from the current date and returns the data.

For instance

Current date= 05/05/2009
Date before two years=current date-(2 years)
Date before two years=MM/DD/YYYY

Appreciate your cooperation

Hi,

The function you want is DateAdd

[CODE=vb]dtPrevious = DateAdd("yyyy", -2, dtCurrent)[/CODE]

Please read the help file for DateAdd for further usage of the Interval argument ("yyyy" in this example).

Jim

[ahd2008]

thanks a lot bro and thx for the advice too

[JustJim]

No problem, glad to be of assistance.

Jim