Rolling Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I query a date field to show a rolling year from today? Thanks much.
 
WHERE datefield between date() and dateadd("yyyy",-1,date())
 
You must log in or register to reply here.

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

Duplicates - Query Joining 1
rolling 3 months query 3
Rolling query 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Monthly quantities to Weekly 1
News UK Smart Meter rollout delayed by 4 more years 15
How to calculate a Rolling Average 2
A query for 12 month rolling values 0

Back
Top