How do I query a date 30 days prior?

  • Thread starter Thread starter Jerry Crosby
  • Start date Start date
J

Jerry Crosby

Subject says it: how do I query a date that is 30 days prior to today?

Additionally, how do I query all dates that are in this month?

Finally, how do I query all dates in this year?

I suspect there are some similarities!

Jerry
 
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

Create query against multiple date fields 8
Average last 30 days for each day in the quarter 7
Return a date range based on today's date 6
Show 0-30 days from Today 4
Query to display highest totals 1
Filtering records by date 2
Filter criteria for a conditional serialdate field in a query 2
Query for multiple due dates 8

Back
Top