Skip to main content
  • EN

Due date calculations are not calculating properly.


I have selected 2 weeks as my "Resolve within", however, it is calculating 2 weeks as 14 days.


Since we are talking about "Business Hours" (Monday - Friday), 2 weeks is not 14 days, 2 weeks is 10 business days.


This skews my reporting, as well as escalations.

capture_15020.png

Hi Chris


I'm moving this Topic to a Ticket, for further analysis


We will continue via Ticket itself


regards
Vijay

Chris, We have resolved this issue and modified the same in the Reports.


Due date calculations are calculating properly. Mycalcu provides lot of online Calculators also included date calculators.  This is easy to use and free. No Need to signup.

It sounds like the system is currently calculating due dates as calendar days rather than business days. Here are a few approaches to adjust this so that it considers only Monday through Friday, excluding weekends:

1. Check for Business Hours Configuration Settings

Some systems have a configuration option that allows you to define working hours (e.g., Monday to Friday, 9 am - 5 pm) or specify that certain calculations use only business days.

  • Settings: Look for "Business Hours" or "Working Days" settings in the application’s configuration area.
  • Custom Due Date Calculation: Some systems also allow you to toggle between calendar days and business days for SLA and due date calculations.

2. Use a Custom Formula or Workflow

If your system allows custom formulas or workflows, you can set up a custom calculation to handle business days only. Here’s an outline of how this could be done:

  • Create a Workflow: When a task is assigned with a “Resolve Within” SLA, use a workflow to calculate the due date by counting only business days.
  • Exclude Weekends in Formula: If using formulas, define “business days” as days that fall between Monday and Friday. This can be done by adding a function or using scripting to check each day, adding it only if it’s a weekday.

3. Using Scripting or Automation Tools

If your platform supports scripting, you can write a function that calculates the due date by skipping weekends:

  • Example Script: Create a loop that iterates through each day, adding one “business day” at a time and skipping weekends (Saturday and Sunday).
  • Automation: Many task management systems (e.g., ServiceNow, Salesforce) offer automation rules that can adjust date calculations based on business hours or working days.

4. Consider Add-On Tools or API Adjustments

Some platforms offer plugins or add-ons specifically for handling business-day calculations. If available, check if there’s an official add-on that provides enhanced date handling for SLAs and due dates.

Summary

To get accurate due date calculations that respect business hours:

  • Check for built-in business day settings in the application’s configuration.
  • Implement custom workflows or formulas if custom logic is allowed.
  • Write a script or automation rule to calculate dates by counting only business days.
  • Explore add-ons or API enhancements to handle these calculations automatically.

By ensuring your due dates are calculated using business days, your reporting and escalation workflows should stay accurate and consistent.

It sounds like the system is currently calculating due dates as calendar days rather than business days. Here are a few approaches to adjust this so that it considers only Monday through Friday, excluding weekends:

1. Check for Business Hours Configuration Settings

Some systems have a configuration option that allows you to define working hours (e.g., Monday to Friday, 9 am - 5 pm) or specify that certain calculations use only business days.

  • Settings: Look for "Business Hours" or "Working Days" settings in the application’s configuration area.
  • Custom Due Date Calculation: Some systems also allow you to toggle between calendar days and business days for SLA and due date calculations.

2. Use a Custom Formula or Workflow

If your system allows custom formulas or workflows, you can set up a custom calculation to handle business days only. Here’s an outline of how this could be done:

  • Create a Workflow: When a task is assigned with a “Resolve Within” SLA, use a workflow to calculate the due date by counting only business days.
  • Exclude Weekends in Formula: If using formulas, define “business days” as days that fall between Monday and Friday. This can be done by adding a function or using scripting to check each day, adding it only if it’s a weekday.

3. Using Scripting or Automation Tools

If your platform supports scripting, you can write a function that calculates the due date by skipping weekends:

  • Example Script: Create a loop that iterates through each day, adding one “business day” at a time and skipping weekends (Saturday and Sunday).
  • Automation: Many task management systems (e.g., ServiceNow, Salesforce) offer automation rules that can adjust date calculations based on business hours or working days.

4. Consider Add-On Tools or API Adjustments

Some platforms offer plugins or add-ons specifically for handling business-day calculations. If available, check if there’s an official add-on that provides enhanced date handling for SLAs and due dates.

Summary

To get accurate due date calculations that respect business hours:

  • Check for built-in business day settings in the application’s configuration.
  • Implement custom workflows or formulas if custom logic is allowed.
  • Write a script or automation rule to calculate dates by counting only business days.
  • Explore add-ons or API enhancements to handle these calculations automatically.

By ensuring your due dates are calculated using business days, your reporting and escalation workflows should stay accurate and consistent.

if you really want to calculate time vsit : contar horas

Terms of Use