dates question

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Need to pull data for a time period. How can I have the
query start from the first day of a month?

i.e. tried in query but results are only from April 30 to
August 31 -> Needed April 1 to August 31

Between DateAdd("m",-4,DateSerial(Year(Date()),Month(Date
()),0)) And DateSerial(Year(Date()),Month(Date()),0)

Any any ideas?

Between DateAdd("m",-4,??) And DateSerial(Year(Date
()),Month(Date()),0)
 
Month([yourdatefield]) = Month(Date()) AND Year([yourdatefield]) =
Year(Date())
hth,
Tim
 
If you want the last five calendar months ending in the last calendar month
(which seems to be what you're asking), you might try criteria something
like this:
=DateSerial(Year(Date()),Month(Date())-5,1) And
Click to expand...
<DateSerial(Year(Date()),Month(Date()),1)
 
Back
Top