Defining an Extended Calendar For the Last Working Day of the Month Minus X Working Days

Document ID : KB000075127
Last Modified Date : 30/03/2018
Show Technical Document Details
Question:
How can I define an extended calendar where the generated dates are the last working day of each month minus x working days? 
Answer:
This type of extended calendar can be accomplished by using the "WORKDMnn" date condition keyword. This keyword specifies that the schedule that is generated by the extended calendar includes the nnth workday of the month, counting backwards. With this keyword, the last workday of the month is considered workday #01 instead of the first workday of the month.

Here is an example of it being used in a definition where the goal was to have dates that are the last working day of the month minus 3 days. Since nn=01 for the last working day of the month using this keyword, nn=04 would be the last working day of the month minus 3 days...
 
Enter Name: test
Enter Description: Enter Workdays [XXXXX..]:
Enter Non-workday Actions [' ',O,S,N,W,P]: P
Enter Holiday Actions [' ',O,S,N,W,P]:
Enter Holiday Calendar [none]:
Enter Cycle Name [none]:
Enter Date Adjustment [0]:
Enter Date Conditions [DAILY]: WORKDM04

Generated Dates are:
                            2018 (MM/DD/YYYY)
 January       2018       February      2018        March          2018
-------------------------    -------------------------        -------------------------
                                                                       03/27/2018 00:00:00
April              2018      May              2018            June           2018
-------------------------    -------------------------        -------------------------
04/25/2018 00:00:00  05/28/2018 00:00:00     06/26/2018 00:00:00
July                 2018     August         2018        September         2018
-------------------------      -------------------------        -------------------------
07/26/2018 00:00:00   08/28/2018 00:00:00     09/25/2018 00:00:00
October              2018 November         2018    December          2018
-------------------------      -------------------------        -------------------------
10/26/2018 00:00:00   11/27/2018 00:00:00     12/26/2018 00:00:00