Need to add 3 years to a date value in a query

[ToyFox]

I have a query with a date field. I need to display that value and add 3 years. Not every row contains a value.
What is the best approach.

 

[SkipVought]

Hi,

Please be more specific. Maybe an example of a row that has a date and a row that has no date. Don't understand your data structure

Now a date plus 3 years issue. Does that mean date plus 365.25 * 3 days, or year of date plus 3; days being constant -- but what happens if the date is February 29? You must be more specific.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[KiaruB]

u need to use the function : DateAdd

like


NewDate = DateAdd("y",3,YourDate)

Greets

 

[ToyFox]

Thanks, I knew there was an easier way.

 

[dhookom]

If you use a single "y" in Access, you will add days, not years. For some reason, you need to use "yyyy".

Duane
Hook'D on Access
MS Access MVP