AnsweredAssumed Answered

Can anyone explain why my extended calendar is missing a date?

Question asked by leroy.graham on Mar 15, 2018
Latest reply on Mar 22, 2018 by leroy.graham

I recently started using extended calendars and cycles to use in our job definitions. I have come across a situation that I just cannot work out why one date is missing and I am wondering if anyone can explain - it is driving me nuts.

 

The objective  is to generate a list of dates for the "Saturday after last Friday each month from January to November".

1. I have defined a cycle

Cycle Name: Monthly_Jan02-Dec01
Start Date  : 01/02/1972 00:00:00
End Date    : 02/01/1972 00:00:00

Start Date  : 02/02/1972 00:00:00
End Date    : 03/01/1972 00:00:00

Start Date  : 03/02/1972 00:00:00
End Date    : 04/01/1972 00:00:00

Start Date  : 04/02/1972 00:00:00
End Date    : 05/01/1972 00:00:00

Start Date  : 05/02/1972 00:00:00
End Date    : 06/01/1972 00:00:00

Start Date  : 06/02/1972 00:00:00
End Date    : 07/01/1972 00:00:00

Start Date  : 07/02/1972 00:00:00
End Date    : 08/01/1972 00:00:00

Start Date  : 08/02/1972 00:00:00
End Date    : 09/01/1972 00:00:00

Start Date  : 09/02/1972 00:00:00
End Date    : 10/01/1972 00:00:00

Start Date  : 10/02/1972 00:00:00
End Date    : 11/01/1972 00:00:00

Start Date  : 11/02/1972 00:00:00
End Date    : 12/01/1972 00:00:00

 

2. The extended calendar definition is;

Name                : Monthly_LastFriPlus1_DoM_xDec
Workdays            :
Holiday Calendar    :
Cycle Name          : Monthly_Jan02-Dec01
Holiday Action      :
Non Workday Action  :
Date Adjustment     : 1
Date Conditions     : CFRI#L

 

3. The dates generated in the extended calendar;

January              2018 February             2018 March                2018
------------------------- ------------------------- -------------------------
                                                    03/31/2018 00:00:00

April                2018 May                  2018 June                 2018
------------------------- ------------------------- -------------------------
04/28/2018 00:00:00                                 06/30/2018 00:00:00

July                 2018 August               2018 September            2018
------------------------- ------------------------- -------------------------
07/28/2018 00:00:00                                 09/01/2018 00:00:00
                                                    09/29/2018 00:00:00

October              2018 November             2018 December             2018
------------------------- ------------------------- -------------------------
10/27/2018 00:00:00                                 12/01/2018 00:00:00

 

As you can see there isn't a date for May 2018, it should be 05/26/2018 00:00:00. I have gone over this umpteen times and I still cannot see why this date is missing,  all the other dates generated are correct, it simply does not make sense  to me.

 

Can anyone offer an explanation or make a suggestion so that I get all the required dates?

 

Thank you

Outcomes