DateAdd with year

[JonFer]

Has anyone noticed problems with using the DateAdd() function and the year ("y") parameter? This is with Access 97. It's probably a leap year thing but if I add a lot of years (e.g. 100), it gets off by a few months. If I switch to using months, it works fine.


John

http://www.interautomateconsulting.com

 

[PHV]

Have you tried "yyyy" as Interval ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JonFer]

What a bonehead! I assumed "y" was year. Thanks.

John

http://www.interautomateconsulting.com

 

[Golom]

That's because "y" doesn't add years ... it adds "day of the year" and is (far as I can tell) equivalent to

DateAdd ( "d", n, Date() )

To add years, try

DateAdd ( "yyyy", n, Date() )