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()
 
You must log in or register to reply here.

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

Amazon are rubbish 14
Group dates by Month 2
Summarise data by Month 7
Calculating Future Months 3
Date Calculation - Astro Calculation 2
Reset running sum on group level 2
Create sums on different groupings? 9
Same dates in report 3

Back
Top