Month To date Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to print a report and only print the current months data to
date.

ie today is 1/6/06 and I would like to show only those values for
1/1/06-1/6/06 but tomorrow I would like for it to go to 1/7/06 and then next
month start all over again.

Any help would be greatly appreciated.

John
 
Field: YourDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) and Now()
 
Back
Top