Between dates

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

How can I get the beginning and ending date to show up in
the query?
Between Date() And DateAdd("m",-1,Date())
Please help!
 
try something more like...

= DateAdd("m",-1,Date()) and <=Date()
Click to expand...



Rick B


How can I get the beginning and ending date to show up in
the query?
Between Date() And DateAdd("m",-1,Date())
Please help!
 
You want the query records to include the Date() and DateAdd("m",-1,Date())
values?

Just add two calculated fields to the query:
TodayDate: Date()
LastMonth: DateAdd("m",-1,Date())
 

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

Help with small result type 2
Multi table query 1
Calculate Quantity between dates 2
query on date 1
More than one calculation with between dates 2
Converted from LINUX time ok, but having issues with the between date. 4
Default Dates 2
IIF Expression with Between Dates criteria 7

Back
Top