dateadd

[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

someone help me?

 

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

 

[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

 

[Dan]

this is so weird it now works i closed out and went
back in and it now works?

 

[Les]

Well, glad it works for you. Happy New Year!

-----Original Message-----
this is so weird it now works i closed out and went
back in and it now works?
.

 

[Dan]

Happy New Year to you all also thanks again

-----Original Message-----
Well, glad it works for you. Happy New Year!

.