Calculating Date Diff using Calendar Days and Business Days

[mballinger]

Hello,

I have a requirement to find a solution that is either OOB or close to OOB to calculate the Date Difference between Business Days and Calendar Days. Business Days are defined as Mon-Friday and Calendar Days would be 7 days a week. We are going to create a separate field on our table that specifies whether our merchants work in Business Days or Calendar Days. 

Does ServiceNow offer an easy way of doing this without have to create Scripts?

Thanks!

[Allen Andreas]

Hi,

There is not a way to do this without a script.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

I'm glad you found a correct answer that worked for you.

My apologies, it wasn't clear you were looking for other suggestions, but more so simply asking if it was possible without scripting, to which I replied above that it was not.

Take care! 🙂

[JP - Kyndryl]

Hi,

Just curious to understand what is the requirement here.

Would it be acceptable to create 2 SLA definitions, one that will fire for merchants working on Business days and one firing for merchants working on Calendar days.

The sla_task created will then contain the good due date for the work.

Regards.

JP

[Hitoshi Ozawa · Accepted solution]

Hi mballinger,

Calendars can be defined in Business Calendar. However, a script is required to check if the date is in a business calendar.

Example of script to validate date with business calendar is provided in the following thread. A script consists of creating GlideSchedule and using .isInSchedule(<date to validate>).

https://community.servicenow.com/community?id=community_question&sys_id=79215be9dbdcdbc01dcaf3231f96...