We help IT Professionals succeed at work.

Automate Dynamic bi-monthly report

trinisunset
trinisunset asked
on
Medium Priority
386 Views
Last Modified: 2012-06-27
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?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
DO you have Crystal Server or similar report manager?
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.