AnsweredAssumed Answered

BOXI Filter

Question asked by mohansrinivas on Sep 3, 2015


Hello All,

 

I need to frame boxi filter on below conditions which will be used on the zschedstart and end dates on the change reports.Details as follows,please help me in the filter formation on the below requirements.Thanks in advance for your help!!!.

 

1.     1)         Frequency: Mon-Fri at 7:30 am

·         Time period: “current business day 1:00 pm – next second business day 12:59 pm”

Note: For Thursdays and Fridays as well, it should consider the same range of business days, that will extend up to Monday and Tuesday respectively.

Ex:  Wednesday 08/26/2015 report, time period: 08/26/2015 1:00 pm – 08/28/2015 12:59 pm

Thursday 08/27/2015 report, time period: 08/27/2015 1:00 pm – 08/31/201 12:59 pm

Friday 08/28/2015 report, time period: 08/28/2015 1:00 pm – 09/01/2015 12:59 pm

 

2.       2)   Frequency: Mon-Fri at 7:30 am

·         Time period: “previous business day 5:59 am – current business day 6:01 am”

 

Note: For Mondays as well, it should consider the same range of business days, that will extend back from Friday until Monday.

Ex: Monday 08/31/2015 report, time period: 08/28/2015 5:59 am – 08/31/2015 5:59 am

 

3.      3)          Frequency: Mon-Fri at 7:30 am

·         Time period: “previous business day 5:59 am – next business day 11:59 pm”

 

Note: For Fridays and Mondays as well, it should consider the same range of business days, that will extend back from Thursday & Friday respectively to Monday and Tuesday respectively.

Ex:  Friday 08/28/2015 report, time period: 08/27/2015 5:59 am – 08/31/2015 11:59 pm

Monday 08/31/2015 report, time period: 08/28/2015 5:59 am – 09/01/2015 11:59 pm

 

4.       4)         Frequency: Only on Mondays and Thursdays

·         Time period for Mondays report: “next Tuesday 12:00 am – next second Monday 11:59 pm”

Ex: Monday 08/31/2015 report, time period: 09/01/2015 12:00 am – 09/14/2015 11:59 pm

·         Time period for Thursdays report: “next Friday 12:00 am – next second Thursday 11:59 pm”

Ex: Thursday 09/03/2015 report, time period: 09/04/2015 12:00 am – 09/17/2015 11:59 pm

 

5.      5)          Frequency: Only on Mondays and Thursdays

·         Time period for Mondays report: “next Tuesday 12:00 am – next Thursday 11:59 pm”

Ex: Mondays 08/31/2015 report, time period: 09/01/2015 12:00 am – 09/03/2015 11:59 pm

·         Time period for Thursdays report: “next Friday 12:00 am – next Monday 11:59 pm”

Ex: Thursday 09/03/2015 report, time period: 09/04/2015 12:00 am – 09/07/2015 11:59 pm

 

6.       6)     Frequency: Mon-Fri at 7:30 am

·         Time period: “current business day 1:00 pm – next second business day 12:59 pm”

Note: For Thursdays and Fridays as well, it should consider the same range of business days, that will extend up to Monday and Tuesday respectively.

Ex: Wednesday 08/26/2015 report, time period: 08/26/2015 1:00 pm – 08/28/2015 12:59 pm

Thursday 08/27/2015 report, time period: 08/27/2015 1:00 pm – 08/31/201 12:59 pm

Friday 08/28/2015 report, time period: 08/28/2015 1:00 pm – 09/01/2015 12:59 pm

Outcomes