Extended calendar which runs on 1st business day of 3rd of every month in autosys

I need to create extended calendar which will run on 1st business day of 3rd week of every month.
Mon to Fri are considered as working day and no holiday calendar included.
Sample dates for year 2018 :
16th Jan, 13th Feb, 13th Mar, 17th Apr, 15th May, 12th Jun, 17th Jul, 14th Aug, 11th Sep, 16th Oct, 13th Nov, 11th Dec

Currently I am using standard calendar for this but wants to change it to extended calendar to avoid manual inserts for every year.

asked Nov 25 '18 at 11:06

Manvi

Please put the code you tried!!

– Rahul Agarwal
Nov 25 '18 at 11:19

I am not 100% clear which code you are asking for, but below is the definition for standard calendar which we are currently using. Calendar_Name: CAL_ABC Description: 1st Business day of 3rd week for every month Date: 01/16/2018 Date: 02/13/2018 Date: 03/13/2018 Date: 04/17/2018 Date: 05/15/2018 Date: 06/12/2018 Date: 07/17/2018 Date: 08/14/2018 Date: 09/11/2018 Date: 10/16/2018 Date: 11/13/2018 Date: 12/11/2018 So generally we mention static dates while creating standard calendar, which we need to update every year. Hope this helps in understanding my question

– Manvi
Nov 25 '18 at 11:46

add a comment |

Currently I am using standard calendar for this but wants to change it to extended calendar to avoid manual inserts for every year.

asked Nov 25 '18 at 11:06

Manvi

Please put the code you tried!!

– Rahul Agarwal
Nov 25 '18 at 11:19

I am not 100% clear which code you are asking for, but below is the definition for standard calendar which we are currently using. Calendar_Name: CAL_ABC Description: 1st Business day of 3rd week for every month Date: 01/16/2018 Date: 02/13/2018 Date: 03/13/2018 Date: 04/17/2018 Date: 05/15/2018 Date: 06/12/2018 Date: 07/17/2018 Date: 08/14/2018 Date: 09/11/2018 Date: 10/16/2018 Date: 11/13/2018 Date: 12/11/2018 So generally we mention static dates while creating standard calendar, which we need to update every year. Hope this helps in understanding my question

– Manvi
Nov 25 '18 at 11:46

add a comment |

Currently I am using standard calendar for this but wants to change it to extended calendar to avoid manual inserts for every year.

asked Nov 25 '18 at 11:06

Manvi

Currently I am using standard calendar for this but wants to change it to extended calendar to avoid manual inserts for every year.

calendar autosys

asked Nov 25 '18 at 11:06

Manvi

asked Nov 25 '18 at 11:06

Manvi

asked Nov 25 '18 at 11:06

Manvi

asked Nov 25 '18 at 11:06

Manvi

asked Nov 25 '18 at 11:06

Manvi

Please put the code you tried!!

– Rahul Agarwal
Nov 25 '18 at 11:19

I am not 100% clear which code you are asking for, but below is the definition for standard calendar which we are currently using. Calendar_Name: CAL_ABC Description: 1st Business day of 3rd week for every month Date: 01/16/2018 Date: 02/13/2018 Date: 03/13/2018 Date: 04/17/2018 Date: 05/15/2018 Date: 06/12/2018 Date: 07/17/2018 Date: 08/14/2018 Date: 09/11/2018 Date: 10/16/2018 Date: 11/13/2018 Date: 12/11/2018 So generally we mention static dates while creating standard calendar, which we need to update every year. Hope this helps in understanding my question

– Manvi
Nov 25 '18 at 11:46

add a comment |

Please put the code you tried!!

– Rahul Agarwal
Nov 25 '18 at 11:19

I am not 100% clear which code you are asking for, but below is the definition for standard calendar which we are currently using. Calendar_Name: CAL_ABC Description: 1st Business day of 3rd week for every month Date: 01/16/2018 Date: 02/13/2018 Date: 03/13/2018 Date: 04/17/2018 Date: 05/15/2018 Date: 06/12/2018 Date: 07/17/2018 Date: 08/14/2018 Date: 09/11/2018 Date: 10/16/2018 Date: 11/13/2018 Date: 12/11/2018 So generally we mention static dates while creating standard calendar, which we need to update every year. Hope this helps in understanding my question

– Manvi
Nov 25 '18 at 11:46

Please put the code you tried!!

– Rahul Agarwal
Nov 25 '18 at 11:19

I am not 100% clear which code you are asking for, but below is the definition for standard calendar which we are currently using. Calendar_Name: CAL_ABC Description: 1st Business day of 3rd week for every month Date: 01/16/2018 Date: 02/13/2018 Date: 03/13/2018 Date: 04/17/2018 Date: 05/15/2018 Date: 06/12/2018 Date: 07/17/2018 Date: 08/14/2018 Date: 09/11/2018 Date: 10/16/2018 Date: 11/13/2018 Date: 12/11/2018 So generally we mention static dates while creating standard calendar, which we need to update every year. Hope this helps in understanding my question

– Manvi
Nov 25 '18 at 11:46

add a comment |

1 Answer
1

active

oldest

votes

@Manvi

not very confident of the exact condition and this would be a partial answer.
as for now i can think of

WEEK#03|WEEK#07|WEEK#11|WEEK#15|WEEK#20|WEEK#24|WEEK#28|WEEK#33|WEEK#37|WEEK#42|WEEK#46|WEEK#50

This would give you all the 3rd week of the the months and then hereon need to exclude the rest of the days.

You can refer this link for condition keywords.

Also, you can use below to include multiple keywords for desired output.

OR condition as "|"

NOT as "NOT"

Hope this helps. Good luck.
Will update incase i do find the solution.

Edits:

The first working day would definitely be a Monday and the previous day has to be 2nd Sunday.

Consider a calender as below

extended_calendar: Cal_name

description: 1st day of the 3rd week

workday: mo,tu,we,th,fr

non_workday:

holiday:

holcal:

cyccal:

adjust: +1

condition: sun#2

Sun#2 would consider the 2nd sunday of all months and the next day would mark the start of the 3rd week.
To consider the next day of the 2nd sunday adjust: +1 defined.

If you are looking for the 2nd day of the 3rd week. Defined adjust to +2.

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466844%2fextended-calendar-which-runs-on-1st-business-day-of-3rd-of-every-month-in-autosy%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

@Manvi

not very confident of the exact condition and this would be a partial answer.
as for now i can think of

WEEK#03|WEEK#07|WEEK#11|WEEK#15|WEEK#20|WEEK#24|WEEK#28|WEEK#33|WEEK#37|WEEK#42|WEEK#46|WEEK#50

This would give you all the 3rd week of the the months and then hereon need to exclude the rest of the days.

You can refer this link for condition keywords.

Also, you can use below to include multiple keywords for desired output.

OR condition as "|"

NOT as "NOT"

Hope this helps. Good luck.
Will update incase i do find the solution.

Edits:

The first working day would definitely be a Monday and the previous day has to be 2nd Sunday.

Consider a calender as below

extended_calendar: Cal_name

description: 1st day of the 3rd week

workday: mo,tu,we,th,fr

non_workday:

holiday:

holcal:

cyccal:

adjust: +1

condition: sun#2

Sun#2 would consider the 2nd sunday of all months and the next day would mark the start of the 3rd week.
To consider the next day of the 2nd sunday adjust: +1 defined.

If you are looking for the 2nd day of the 3rd week. Defined adjust to +2.

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

add a comment |

@Manvi

not very confident of the exact condition and this would be a partial answer.
as for now i can think of

WEEK#03|WEEK#07|WEEK#11|WEEK#15|WEEK#20|WEEK#24|WEEK#28|WEEK#33|WEEK#37|WEEK#42|WEEK#46|WEEK#50

This would give you all the 3rd week of the the months and then hereon need to exclude the rest of the days.

You can refer this link for condition keywords.

Also, you can use below to include multiple keywords for desired output.

OR condition as "|"

NOT as "NOT"

Hope this helps. Good luck.
Will update incase i do find the solution.

Edits:

The first working day would definitely be a Monday and the previous day has to be 2nd Sunday.

Consider a calender as below

extended_calendar: Cal_name

description: 1st day of the 3rd week

workday: mo,tu,we,th,fr

non_workday:

holiday:

holcal:

cyccal:

adjust: +1

condition: sun#2

Sun#2 would consider the 2nd sunday of all months and the next day would mark the start of the 3rd week.
To consider the next day of the 2nd sunday adjust: +1 defined.

If you are looking for the 2nd day of the 3rd week. Defined adjust to +2.

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

add a comment |

@Manvi

not very confident of the exact condition and this would be a partial answer.
as for now i can think of

WEEK#03|WEEK#07|WEEK#11|WEEK#15|WEEK#20|WEEK#24|WEEK#28|WEEK#33|WEEK#37|WEEK#42|WEEK#46|WEEK#50

This would give you all the 3rd week of the the months and then hereon need to exclude the rest of the days.

You can refer this link for condition keywords.

Also, you can use below to include multiple keywords for desired output.

OR condition as "|"

NOT as "NOT"

Hope this helps. Good luck.
Will update incase i do find the solution.

Edits:

The first working day would definitely be a Monday and the previous day has to be 2nd Sunday.

Consider a calender as below

extended_calendar: Cal_name

description: 1st day of the 3rd week

workday: mo,tu,we,th,fr

non_workday:

holiday:

holcal:

cyccal:

adjust: +1

condition: sun#2

Sun#2 would consider the 2nd sunday of all months and the next day would mark the start of the 3rd week.
To consider the next day of the 2nd sunday adjust: +1 defined.

If you are looking for the 2nd day of the 3rd week. Defined adjust to +2.

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

@Manvi

not very confident of the exact condition and this would be a partial answer.
as for now i can think of

WEEK#03|WEEK#07|WEEK#11|WEEK#15|WEEK#20|WEEK#24|WEEK#28|WEEK#33|WEEK#37|WEEK#42|WEEK#46|WEEK#50

This would give you all the 3rd week of the the months and then hereon need to exclude the rest of the days.

You can refer this link for condition keywords.

Also, you can use below to include multiple keywords for desired output.

OR condition as "|"

NOT as "NOT"

Hope this helps. Good luck.
Will update incase i do find the solution.

Edits:

The first working day would definitely be a Monday and the previous day has to be 2nd Sunday.

Consider a calender as below

extended_calendar: Cal_name

description: 1st day of the 3rd week

workday: mo,tu,we,th,fr

non_workday:

holiday:

holcal:

cyccal:

adjust: +1

condition: sun#2

Sun#2 would consider the 2nd sunday of all months and the next day would mark the start of the 3rd week.
To consider the next day of the 2nd sunday adjust: +1 defined.

If you are looking for the 2nd day of the 3rd week. Defined adjust to +2.

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

edited Nov 28 '18 at 22:25

answered Nov 25 '18 at 21:07

Piyush

287

answered Nov 25 '18 at 21:07

Piyush

287

answered Nov 25 '18 at 21:07

Piyush

287

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

add a comment |

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

Thanks piyush !! But we have one issue with the condition you have mentioned. The keyword WEEK#nn considers week from the year, which won't work here because sometimes we have 5 week in a month and because of that we cannot give which week to pickup in every month

– Manvi
Nov 27 '18 at 3:21

Pls try out the other way pointed below edits in the answers. This should work.

– Piyush
Nov 28 '18 at 22:09

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Ytukyg