Query 365 days or 12 months

G

Guest

I need to write criteria to retrieve only the last 365 days or 12 months of
data from the standard date field (eg. 5/12/2004). This is probably easy for
most of you, but please indulge me... Thanks so much!
 
G

Guest

I'm sorry for the duplicate post, I had an error message both times I tried
to send it. Thanks again!
 
P

PC Datasheet

Between DateAdd("yyyy",-1,Date()) And Date()

This expression gives you:
Between 10/29/2003 and 10/29/2004
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Brackets as an IIf statement 3
Query last 365 days or 12 mo. 1
Calculated field won't display properly 4
Query - pull past 12 months 1
Date Query using date in the date field 3
making age group query work 7
Query that eliminates an entry if another one is retieved 3
Query for multiple due dates 8

Top