Questions tagged [businesshours]
The businesshours tag has no usage guidance.
81
questions
-1
votes
1
answer
29
views
How the field BusinessHoursId in Case record gets populated [closed]
In my org, I have two different Business Hours:
Default(it is the default one)
FS-Default
Both are active.
I have couple of RecordTypes in the Case object. Now, I need to populate field ...
-1
votes
1
answer
33
views
I have a requirement to check if date given on object is greater than today's but should be less than next 5 business days. How to apply that logic?
I am able to calculate easily if it is greater than today.
setConditionalFormatting(){
if(this.myTaskWrappers){
this.myTaskWrappers = this.myTaskWrappers.map(item => {
...
- 54
0
votes
1
answer
456
views
Deploying reports: columns-field: Invalid value specified: BUSINESS_DURATION
In my CI/CD pipeline, when I deploy from Org A -> version control -> Org B after developing a report in Org A, I get the following error for the report in question
columns-field: Invalid value ...
- 69.9k
0
votes
0
answers
83
views
Milliseconds issue, how convert 00h to 24, 01h to 25, 02h to 26..?
I have a LWC component that is a calendar, he verify the begin and end time of the company to put the interval of this hours, the problem is, when the hour is 00 or 01 or 02.. because of the way that ...
- 81
0
votes
0
answers
619
views
Calculate business hours between case creation and closing date (Mon-Fri 9am to 5pm)
I want to calculate the total number of business hours it took to close the case. The working hours are Monday to Friday 9am to 5pm (8 hours a day).
I wrote the following formula but it is giving ...
- 15
0
votes
1
answer
281
views
Operating Hours Holidays causing deployment error for BusinessHours.settings
We are implementing Salesforce Scheduler and have encountered a serious issue with our automated deployments following the implementation of the Operating Hours Holidays functionality.
When these ...
- 1,748
2
votes
1
answer
466
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 ...
- 808
0
votes
2
answers
165
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 ...
- 997
1
vote
1
answer
2k
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
311
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
2k
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
2k
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 ...
- 63
0
votes
1
answer
652
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 ...
- 9,187
3
votes
1
answer
2k
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,765
1
vote
1
answer
268
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 ...
- 1,227
0
votes
1
answer
176
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,774
0
votes
0
answers
374
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. ...
- 866
1
vote
1
answer
223
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
157
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
278
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
1k
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.
- 417
0
votes
1
answer
1k
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,114
0
votes
1
answer
851
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 = ...
- 111
3
votes
1
answer
395
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
941
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 ...
- 135k
0
votes
1
answer
947
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,415
1
vote
1
answer
1k
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,171
1
vote
1
answer
504
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 ...
- 13
1
vote
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,431
3
votes
2
answers
984
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];
...
- 5,077
1
vote
1
answer
301
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,431
1
vote
1
answer
54
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
990
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
1k
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 ...
- 115
1
vote
1
answer
685
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,920
1
vote
1
answer
98
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,415
1
vote
1
answer
956
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 ...
- 13k
2
votes
1
answer
229
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,171
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 ...
- 129
0
votes
2
answers
4k
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 ...
user48562
-1
votes
2
answers
1k
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,616
-1
votes
1
answer
42
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,616
3
votes
4
answers
47k
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 ...
- 349
0
votes
1
answer
959
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:...
- 349
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, ...
- 1,958
0
votes
2
answers
139
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 ...
- 349
0
votes
1
answer
113
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 ...
- 349
1
vote
0
answers
744
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 ...
- 11
0
votes
2
answers
82
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'...
