Questions tagged [businesshours]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
96 views

Does Date.addDays() method skip the weekends based on the Org's Business Hours settings?

For example when I use Date.addDays(1) for a task's due date. I realized if the next day falls into a weekend both Sat and Sun are skipped and it adds 1 workday (which is three days count). Now, this ...
  • 650
0 votes
2 answers
64 views

Mocking BusinessHours records returns System.MathException: null

I am stuck on a test method and any help would be highly appreciated. To provide some context: I created a method that queries a specific BusinessHours record on the DB and validates if a Case was ...
1 vote
1 answer
552 views

When calculating business hours between two dates, value is rounded to whole number

I have a formula field that calculated the difference in business hours between two dates from field MQL_Response__c and field MQL_Created__c. The hours are calculating correctly, but it rounds to a ...
  • 11
2 votes
0 answers
114 views

Remaining place in queue after closing hours in Salesforce chat

I'm setting up a chat solution for a firm right now, where they have opening hours for their chat service. The chat would tipically be open from 08:00-16.00. After closing hours, no customers should ...
  • 39
0 votes
1 answer
1k views

Number Formula - Two Date/Time Field Difference Within Business Hours

I have a formula field (FirstCallDif__c) that shows in minutes the difference between two fields: (FirstCall__c - CreatedDate) *24*60 This gives us the minutes however some leads do come in at say ...
1 vote
1 answer
940 views

Calculating Business Hours via Trigger and Class

I currently have business hours / Holidays removed from business hour calculations using formula fields. The issue with that is, is an employe works on a holiday or weekend, the formula shows a ...
  • 53
0 votes
1 answer
494 views

How to respond to Einstein Bot after-hours message during business hours?

Background A Facebook Messenger Einstein Bot has an business-hours check as the first action, if it is out of business-hours it sends a message informing them that no one is available. Question How ...
  • 8,480
3 votes
1 answer
1k views

How to check if a Date is within Business Hours for Multiple TImezones

I am working on a requirement to update a field if the LastModifiedDate lies within the Business hours of the user, viz. Monday to Friday between 8 AM to 5 PM. I have tried using the BusinessHours ...
  • 2,674
1 vote
1 answer
88 views

Long to Double Calculation Getting Rounded to Zero Incorrectly [duplicate]

I'm doing a fairly simple calculation to compute the difference in Business Hours between two DateTimes. This is largely functional, but in the case of short differences (~10 minutes) this gets ...
0 votes
1 answer
103 views

BusinessHours methods not compiling

For some reason when I attempt to use the BusinessHours.isWithin method within Salesforce I get the following error: Compile failure on line 4, column 34: Method does not exist or incorrect signature:...
  • 1,732
0 votes
0 answers
103 views

Salesforce formula to exclude holidays between two date time fields

I would like to create one formula field on Case object which calculates business hours between two dates. Weekends, as well as Holidays mentioned in Business hours, should be excluded in the formula. ...
1 vote
1 answer
179 views

Test Class for Business Hours Check

I am trying to build a test class for my new trigger and part of the trigger is to check current time against the org business hours then set it as a boolean yes/no. Code: DateTime now =system.Now();...
1 vote
1 answer
85 views

Setting due dates for autogenerated cases

Based on a business days value (1 = business day 1, 12=business day 12) and taking account of the below I would like to generate a due date based on a created date. - Default business hours, - ...
0 votes
1 answer
167 views

Trigger Run Outside of Business Hours

I have my simple trigger working now where once a threshold is met for cases created within 60 minutes it updates the "SendAlert" field so my workflow can start going to work. The next steps I am ...
0 votes
1 answer
708 views

how do i give permission of updating business hours to a normal user other than system administrator?

Is there a way we can give a normal user with the previlage of updating business hours and holidays in salesforce? Any supporting URL would be really helpful. Thanks in advance.
  • 407
0 votes
1 answer
637 views

Why is my entitlement not stopped during support holidays?

I have an entitlement process with a single milestone in it. I've created a support holiday and linked it to the business hours record I have set up on the milestone and on the entitlement process. ...
  • 1,084
0 votes
1 answer
594 views

Business Hours calculation is incorrect/ not consistent for certain dates

My use case is to calculate the deadline to respond on the Case. Rule is to add 10 business days from the complaint received date. Defined the business hours: Logic 1 Date initialDate = ...
3 votes
1 answer
308 views

Businesshours.nextStartDate is returning value which is on a holiday

In our org, I have set-up business hours as 08:00-16:00 and timezone is GMT +2. Saturdays and Sundays are blank which means they are holidays. I then went in and set-up Holidays and have put the 24th,...
  • 93
6 votes
2 answers
640 views

Does SFDX add any way of automating the setup of business hours?

It wasn't (and I assume still isn't?) possible to programmatically set up business hours via Apex code in unit tests: Set Business Hours in Apex Test Code Creating Holidays and Business Hours in Test ...
  • 131k
0 votes
1 answer
772 views

Escalate case using business hours

We are using process builder to escalate a case and send email notifications to specific queues. The escalation works using scheduled actions...i.e. after 1 hour send email, after 2 send another email ...
  • 2,353
1 vote
1 answer
907 views

Business Hours difference calculation during BST

Hello I need help understanding how business hours difference is calculated with the Apex class. The documentation is rather poor and doesn't explain the input parameters assumptions. I found one post ...
  • 1,149
1 vote
1 answer
406 views

Update action in x business hours

I have a requirement where I need to send email in 8 business hours. It should respect holidays and weekends. Example: Office Hours 8 AM to 5 PM If case is created at 4 PM Friday then email must be ...
0 votes
0 answers
1k views

BusinessHours.isWithin() Not Working As Expecting

I am using the BusinessHours class and am just running some basic tests: BusinessHours bh = [SELECT Id, ThursdayStartTime FROM BusinessHours WHERE IsDefault = true]; if (BusinessHours.isWithin(bh.Id, ...
  • 3,245
3 votes
2 answers
541 views

Does BusinessHours diff() method work with standard CreatedDate field in Before Update Trigger?

I will start off with a code snippet: trigger CaseTrigger on Case (before insert, before update) { BusinessHours defaultHours = [select Id from BusinessHours where IsDefault=true]; ...
  • 4,767
1 vote
1 answer
201 views

BusinessHours and scheduled dates

I am trying to create a payment schedule off of a input field DATE. If the date falls on a Weekend or on a Holiday then I want to move the payment date to the next open business day. I was using the ...
  • 3,245
1 vote
1 answer
45 views

Need to add only business days

In Opportunity i created a formula date field. in which i want only it take business days means like:TODAY() + ( ( ( 0.7 * ( Total_Payback_Amount__c ) ) - Total_Collected_to_Date__c ) / ...
  • 35
1 vote
0 answers
803 views

Create Test data within business hour and outside of business hours?

I have below code and for that I am trying to write the test classes. As per code look like Case should be created within Business hours and other condition says that, case should be created outside ...
  • 161
0 votes
1 answer
878 views

Add 5 Business days calculates wrong Target Date value in salesforce?

Business hours is set to 7 AM to 7 PM Mon to Fri, Time Zone (GMT-05:00) Eastern Standard Time (America/New_York). I need to simply add 5 working days from Current Date in order to calculate the ...
1 vote
1 answer
506 views

BusinessHours API not returning correct isWithin() value

I'm trying to use APEX BusinessHours class to check whether a certain Date is a Business Day or Not. Here is my Business Hour in my Organization: Based on this, if I provide following date input, it ...
  • 5,686
1 vote
1 answer
84 views

Hitting CPU Limit using BusinessHours

I am working on a method that adds business days using the BusinessHours class. Here is the method I'm working on: public static Date addBusinessDays(Date d, integer dayDifference, Id ...
  • 2,353
1 vote
1 answer
748 views

Find the next several days time according to business hours

I need to build a formula based on the start time, order type and business hours. start time and due time are datetime. The difficult part about this is I need to calculate this around the business ...
  • 12.8k
2 votes
1 answer
149 views

Apex Business Hours calculation glitch

I have a salesforce org with business hours set up from 8AM - 6PM (10 hours). Corporate holidays are on 25,26th Dec and 1st Jan. I'm using the standard apex method BusinessHours.add() to calculate ...
  • 1,149
1 vote
1 answer
2k views

Business Hours and Time Zones (EDT vs EST?)

I have trigger code that is calculating the span between two Date/Time fields - respecting Business Hours - easy. Business Hours end daily at 5pm - and the Time Zone is set to EST (however we're ...
0 votes
2 answers
3k views

Calculate No of working days difference between two dates?

This could be the very simple use case, but I am straggling to make this working. How we can find out the business working days difference between two dates ? I know 8/26/2017 is Saturday, next days ...
user avatar
-1 votes
2 answers
846 views

Method does not exist or incorrect signature: [BusinessHours].diff(Id, Time, Time) [duplicate]

I am working on the BusinessHours and I am getting the below error. I just want to calculate the no. of hours difference between MondayStartTime and MondayEndTime Method does not exist or incorrect ...
  • 1,550
-1 votes
1 answer
38 views

Incompatible element type Time for collection of Datetime for BusinessHours

I working to calculate the business hours from the Business day: List<BusinessHours> bhList = [SELECT FridayEndTime,FridayStartTime,Id,IsActive,IsDefault,LastModifiedById, ...
  • 1,550
3 votes
4 answers
37k views

How can I get my correct current local time?

I need to get the current time but to be in type DateTime. I use: DateTime now = System.now(); but it returns wrong time. I execute the code in 2017-08-04 00:38:46 AM but it returns 00:38:46:023 ...
  • 353
0 votes
1 answer
764 views

DateTime set to an hour earlier

I have an object of type Time startWorkingTime and object of type DateTime nextBusinessDay. I want to create new object of type DateTime based on startWorkingTime and nextBusinessDay. Here is my code:...
  • 353
1 vote
2 answers
1k views

BusinessHours class returns incorrect time difference

I am using business hours class to get the hours, minutes difference between when a lead is assigned to a user and when it is acted upon. The business hours are 7 AM to 4 PM from Monday to Friday, ...
0 votes
2 answers
118 views

Calculate hours based on Task priority

I need help to achieve the following: When a Task priority is changed by a particular user, I must set a fixed amount of REAL (non-working) hours in a custom field in the same Task. The purpose is to ...
  • 353
0 votes
1 answer
84 views

How do I get time spent on a Task, excluding Holiday and Non-working hours?

How do I get time spend on a Task, excluding Holiday and Non-working hours? I'd like to get the total time spent on a Task, excluding holidays and non working hours. Is there a feasible way and how ...
  • 353
1 vote
0 answers
611 views

Minutes between 2 Datetime fields excluding weekends

I pulled a formula from the Success boards to calculate the total minutes between 2 date/time fields, but exclude weekend hours. However, it is spitting out a value of "0" when the value should ...
0 votes
2 answers
61 views

Counting Business days

I am looking to count business days from when a status is picked in a pick list on a case. I have the field awaiting customer input data adding today's date when the status is picked. This is working ...
  • 1
1 vote
1 answer
3k views

Calculation of business hours between two date time fields

Id businessHoursId = [select Id from BusinessHours where isdefault = true ].id; DateTime dateTime1 = Datetime.valueOf('2015-07-10 12:00:00'); DateTime dateTime2 = Datetime.valueOf('2015-07-13 12:00:00'...
1 vote
2 answers
480 views

How to trigger email after last modified but within business hours

I have Business Hours enabled in my org. I have created a process builder which triggers an email 24 hours after last modified date of a particular case. However I am not being able to understand ...
  • 61
1 vote
1 answer
1k views

not being able to query BusinessHours in Case object

I have set up Business Hours in my org. A field called BusinessHours appears in the Case Standard field List. However as soon as I try to query using workbench, it throws an error select ...
  • 61
3 votes
1 answer
2k views

How are Business Hours added to a case?

I am just learning SF and I am noticing that there seems to be no rhyme or reason with what business hours get set on a case. I opened 8 cases. Two cases Email-to-Case and two through our customer ...
  • 465
0 votes
2 answers
725 views

Test Class for using Business hours to create a task on lead

I am work on test class for the following code. The code uses the business hours from Salesforce and applies a task to anything lead that comes in after business hours. The issue is I cant get the ...
0 votes
1 answer
1k views

How to calculate Hours and minutes using Business Hours?

I have used this to calculate hours , but minutes part is not getting covered. long businessMillisecondsDiff = BusinessHours.diff(bh.Id,cs.CreatedDate,system.now()); decimal businessHoursDiff = ...
0 votes
3 answers
5k views

Add days to created date excluding weekend and holidays

I have written the following code . But it's not giving result nor any error. My requirement is to add 3 days to CreatedDate, excluding weekend and holidays. Datetime createdDate = system.now(); ...