2month query

[daneo2k3]

hi i have a query which from a courses table should show a list of people and what courses they have taken which expire in two months from the current date (the current date being the date the query is run) i have the following in the criteria to run this query

>=DateAdd("m",-2,Date())

but when i do run it it shows dates which expire in aug 2007 and others like it so basically it wont work! can anybody help me to get this query to run properly. much appreciatted. Dane

 

[ColinEssex]

Between Date() and DateAdd("m",2,Date())

 

[Mile-O]

Just so that you know what you had done...

...your original criteria gets the date from two months ago and asks for every record after that date.

 

[ColinEssex]

Sorry Mile-O,

I should have explained that but was just leaving for home and typed it very quickly to get the user started.

Col

 

[Mile-O]

You finish at 16:19 on a weekday? What an irregular time. Or were you just sneaking out?

 

[ColinEssex]

I usually finish at 4:15. (I do start before 8am though)

Col