Help!!!!!! Please!!!!

[fenerfan]

hey all,

the Help I have recieved on these forums has been incredible, so I thought I might give it another shot......

One of the attributes in my table is a date and I want to query it so that I filter out those dates that are older than 2years from the current system date,

How Would I do this??????

 

[boblarson]

I'm assuming when you say "filter out" that you mean exclude.

If so, then the query criteria would be:

> DateAdd("y", 2, Date())

 

[fenerfan]

thanks a bunch mate!!!!!!!

 

[normski]

Just a quick hint, when asking for help on the forums state what you want help with in a few words in the title of your thread. if you don't no one will know what you want by looking at the topic list and they will most likely leave it alone since they don't have the time to open all the threads with "Help needed" in the title.