Between dates

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!
 
R

Rick B

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!
 
K

Ken Snell

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())
 
Top