A date query

[macky]

i have a field in a database that has the date of issue date for a radio battery, these batteries a guarenteed for 12 months of use. What can I put in the query under this date field to sort the data for any date over 12 months when the date format is like 27/11/02.

Thanks for your prompt reply.

 

[mwolf00]

SELECT * FROM myTable WHERE issDate < Date() - 365 -- Just trying to help...
<--- This is a wolf? We need a new icon.......
mikewolf@tst-us.com

 

[macky]

Thanks for your help but I think I've made a pigs ear with your answer, in the query design view, I have a field called Battery start date, I changed the option for the Total field to &quot;Where&quot; and in the criteria field I put your expression <Date()-365. Unfortunately it didn't work, so I must be doing something wrong.

Can you help.

 

[r937]

where datediff(&quot;d&quot;,startdate,date()) > 365


rudy