Date criteria > 1 year old

jonesy

Registered User.
Local time
Today, 22:01
Joined
Jan 23, 2003
Messages
17
Hi,

I have a query with which I need to extract the records that are older than 1 year from today.

My date is in Short Date format, can anyone tell me what I need to put into the criteria for this please?

Thanks in advance
 
Thanks Mile-O-Phile, works great.
 

Users who are viewing this thread

Back
Top Bottom