DKirksgirl
Technical User
I have to create a report in which the time periods will be outlined like the following:
Monthly -
See example below:
Jan 14th business day through Feb 13th business day (run on Feb 14th business day for this time period)
So, in a nutshell the report will run monthly on the 14th business day, for the prev month 14th business day through the current month 13th business day
Quarterly -
Works kind of the same way, except
Quarters would be defined like the following.
Jan 14th business day through Apr 13th business day (run on Apr/14th business day for previous Jan 14th business day through Apr 13th business day.
Apr 14th business day through Jul 13th business day (run on Jul/14th business day for previous Apr 14th business day through Jul 13th business day
Jul 14th business day through Oct 13th business day (run on Oct/14th business day for previous Jul 14th business day through Oct 13th business day
Oct 14th business day through Jan 13th business day (run on
Jan 14th business day of the next year for previous year Oct 14th business day through next year Jan 13th business day.
Annual
Defined as Jan 14th business day current year through Jan 13th business day next year (to be run on Jan 14th business day of next year)
I know this is a lot - but I wanted to be thorough. I do wish to exclude holidays.
Thanks in advance for your help.
dkirksgirl@comcast.net
Monthly -
See example below:
Jan 14th business day through Feb 13th business day (run on Feb 14th business day for this time period)
So, in a nutshell the report will run monthly on the 14th business day, for the prev month 14th business day through the current month 13th business day
Quarterly -
Works kind of the same way, except
Quarters would be defined like the following.
Jan 14th business day through Apr 13th business day (run on Apr/14th business day for previous Jan 14th business day through Apr 13th business day.
Apr 14th business day through Jul 13th business day (run on Jul/14th business day for previous Apr 14th business day through Jul 13th business day
Jul 14th business day through Oct 13th business day (run on Oct/14th business day for previous Jul 14th business day through Oct 13th business day
Oct 14th business day through Jan 13th business day (run on
Jan 14th business day of the next year for previous year Oct 14th business day through next year Jan 13th business day.
Annual
Defined as Jan 14th business day current year through Jan 13th business day next year (to be run on Jan 14th business day of next year)
I know this is a lot - but I wanted to be thorough. I do wish to exclude holidays.
Thanks in advance for your help.
dkirksgirl@comcast.net