Questions tagged [businesshours]
The businesshours tag has no usage guidance.
73
questions
0
votes
1answer
38 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 ...
0
votes
0answers
23 views
Using metadata api to set up BusinessHours for unit tests
I am looking at using the standard Salesforce BusinessHours configuration for a project. It is unfortunately not possible to insert this object using DML, which presents a challenge when writing ...
1
vote
1answer
83 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 ...
0
votes
0answers
203 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 ...
3
votes
1answer
139 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 ...
1
vote
1answer
23 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
1answer
30 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:...
0
votes
0answers
32 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
1answer
73 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
1answer
24 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
1answer
76 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
1answer
163 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.
0
votes
1answer
229 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.
...
0
votes
1answer
209 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
1answer
213 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,...
6
votes
2answers
243 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 ...
0
votes
1answer
536 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 ...
1
vote
1answer
543 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
vote
1answer
267 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
0answers
606 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
votes
2answers
152 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];
...
1
vote
1answer
84 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 ...
1
vote
1answer
35 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 ) / ...
1
vote
0answers
443 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 ...
0
votes
1answer
568 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
1answer
263 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 ...
1
vote
1answer
73 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 ...
1
vote
1answer
447 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 ...
2
votes
1answer
85 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 ...
0
votes
1answer
929 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
2answers
2k 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 ...
-1
votes
2answers
642 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
votes
1answer
37 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,
...
0
votes
4answers
22k 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 ...
0
votes
1answer
524 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:...
1
vote
2answers
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
2answers
86 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 ...
0
votes
1answer
72 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 ...
1
vote
0answers
490 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
2answers
46 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
vote
1answer
2k 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
2answers
381 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 ...
1
vote
1answer
709 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 ...
3
votes
1answer
1k 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 ...
0
votes
2answers
487 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
1answer
754 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
3answers
3k 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();
...
0
votes
1answer
31 views
Method does not exist in business hour?
BusinessHours oBh = [SELECT Name,Id FROM BusinessHours where name='FR'];
datetime leaCreatedDate =DateTime.now();
Long slaSeconds =864000000;
system.debug('oBh<<'+oBh.id);
system.debug('oBh&...
3
votes
1answer
532 views
Send email alert exactly after 4 business hours from Task Created Date
We have a requirement to send an email alert to users after 4 business hours from Task Creation Date ie., Our Business hours are from 7am to 5pm (Monday to Friday) and if Task is created at 4pm on ...
1
vote
1answer
55 views
How to utilize buisnessHours class instead of time class
I have a main if statement in my class that utilizes CreatedDate.hour() to execute certain code between 6pm and 8.59am and the ELSE is 9am to 5.59pm which would be within business hours if I could get ...
