Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Monarch Classic- how to capture business days between two dates?

i am trying to capture the number of business days between two dates in monarch classic, but there is no macro for this.

as a work around i have been using age(date1,date2,4)/7*5. So this will take the number of days between the two, divide out the number of approximate weeks then multiply times 5 days per week.

hoping someone has something exact.

Find more posts tagged with

Monarch

Accepted answers

Nicholas_21406

Alrighty - there should be in your C:\Users\Public\Documents\Altair Monarch\Models\UserDefinedFunctions.dmod file on your system. To make this additional functionality available to you, got into Table Design mode, select the functions tab, than Manage External Function and Add External Model

Now when you build a new calculated field, you will have the _WorkingDays_ComputeNormalWorkingDaysInRange function available to you:

All comments

Nicholas_21406

Hi @alberth I don't yet have an answer for you, but may I confirm that when you talk about the number of business days, you mean the number of weekdays between two dates? And you are counting holidays as business days if they fall on Monday through Friday?

alberth

yes, i would like to know weekdays mon-fri in between two dates. i am counting holidays as business days.

Nicholas_21406

Now when you build a new calculated field, you will have the _WorkingDays_ComputeNormalWorkingDaysInRange function available to you:

Nicholas_21406

p.s. If you had to write the formula yourself, you were on the right track.

age(date1,date2,4)/7

is doing integer division, meaning you would get the number of whole weeks between the two days. To get the number of extra days you would apply modulo 7 to that number. Then, based on the day of the week which corresponded to the first and second dates, you would add 0, 1 or 2 days, for the number of weekend days which fell between the two days.

alberth

this is great!! had no idea this existed. is there a way to also exclude holiday weekdays?

Nicholas_21406

Before making any changes to UserDefinedFunctions.dmod, you should save a backup copy of it.

If you edit the _WorkingDays_ComputeDaysOffInRange function, you will see the function has 2006 and 2007's holidays defined. You can change that to be 2025 and 2026's holidays and then all of the WorkingDays functions should reflect this. (Note that the holidays will change from year to year depending on whether they fall on a weekend - you can also add or remove holidays.

I suggest playing with this and let me know how far you can get - if you are still stuck, go ahead and send me the UserDefinedFunctions.dmod that you have so far.

alberth

when i go to function screen im not able to see all the userdefined functions that i just added. how

Nicholas_21406

Hi @alberth ,

At this point it would make sense to get on a screensharing session with you, which will require you to open a Support ticket. Please login support.altair.com with your Altair One credentials, or else create a new account there, and then open a new Support ticket.

Please reference this discussion and ask if the ticket could be assigned to me nlinsky@altair.com.