Between Month Beginning Date and Month End Date

[Guest]

In a date field, you can set the criteria as 'Between Date()-7 and Date()-1'
for a weekly report. How do you set the criteria for monthly?

 

[fredg]

In a date field, you can set the criteria as 'Between Date()-7 and Date()-1'
for a weekly report. How do you set the criteria for monthly?

Where Format([DateField],"mm/yyyy") = Format(Date(),"mm/yyyy")

 

[Duane Hookom]

Set the Field expression to Format([YourField],"yyyymm") and set the
criteria to
Format(Date(),"yyyymm").

 

[John Vinson]

In a date field, you can set the criteria as 'Between Date()-7 and Date()-1'
for a weekly report. How do you set the criteria for monthly?

Fred and Duane have one method; another (to get the records for the
current month) would be to use a criterion on the date field of

= DateSerial(Year(Date()), Month(Date()), 1) AND < DateSerial(Year(Date()), Month(Date()) + 1, 1)

This has the advantage that the search will make use of any indexing
on the datefield.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Or to always look at last month
Between DateSerial(Year(Date()),Month(Date())-1,1) And
DateSerial(Year(Date()),Month(Date()),0)

Cheers

Mark

 

[Guest]

Thank you very much. Worked like a charm!

Or to always look at last month
Between DateSerial(Year(Date()),Month(Date())-1,1) And
DateSerial(Year(Date()),Month(Date()),0)

Cheers

Mark