Automate Dynamic bi-monthly report

I would like to automate a report on the 15th of each month to get the 1st to 14th data.  I would then like the report to run at the end of the month to get the 15th to the end of that month.  Can you help?
trinisunsetAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
What tools do you have to automate or schedule the report?

You can setup a selection formula like this if you run it on the 15th and 1st

If Day(Today) = 15 then
    {YourDateField} In DateSerial(Year(Today), Month(Today),1) to DateSerial(Year(Today), Month(Today),14)
Else
    {YourDateField} In DateSerial(Year(Today), Month(Today)-1,15) to Today -1

If you want to be able to run it on other days of the month define the range and a similar formula can be produced.
For instance running any day 1-14 uses the last half of last month and any other day use first half of this month

mlmcc
0
 
peter57rCommented:
DO you have Crystal Server or similar report manager?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.