dateadd

D

dan

i used this function >DateAdd("m",-3,Date()) to give me
months prior to current date it worked i assumed i
could use the same function for the year and put in
DateAdd("yyyy",-3,Date()) but it doesnt work could
Click to expand...
someone help me?
 
L

Les

Dan,
It worked right for me. What do you get?

-----Original Message-----
i used this function >DateAdd("m",-3,Date()) to give me
months prior to current date it worked i assumed i
could use the same function for the year and put in
someone help me?
.
Click to expand...
 
J

John Spencer (MVP)

What do you mean "it doesnt work"? Do you get an error message? No Records?
The wrong Records? Too many records? Too few Records?

What you have shown should return all records where the date field is later than
3 years ago. In other words all records where the date field is after December
31, 2000. Is that what you want?

If you want all records from Jan 1, 2000 then you would need
 
Top