Apex Code Development You need to sign in to do that
Don't have an account?
Sugirtha Manohar 1 Business Days calculation for Date/Time field
Hi,
We are have an "incident opened date" custom field with data type Date/Time.
Can you please help me with creating a formula field to calculate the business days.
I have tried many business day calculations from various post, however, they do not seem to take the time factor into account.
We are not too particular about the business hours.
For ex., if an incident is opened on Friday at 3p.m. on Monday at 3p.m. we would like the age to be 1 and on Tuesday at 3 p.m. the age would be 2.
Any assistance you provide would be much appreciated.
Thank you!
We are have an "incident opened date" custom field with data type Date/Time.
Can you please help me with creating a formula field to calculate the business days.
I have tried many business day calculations from various post, however, they do not seem to take the time factor into account.
We are not too particular about the business hours.
For ex., if an incident is opened on Friday at 3p.m. on Monday at 3p.m. we would like the age to be 1 and on Tuesday at 3 p.m. the age would be 2.
Any assistance you provide would be much appreciated.
Thank you!
You have same solutions
https://help.salesforce.com/articleView?id=000004526&type=1
https://success.salesforce.com/answers?id=90630000000hWyVAAU
https://developer.salesforce.com/docs/atlas.en-us.usefulFormulaFields.meta/usefulFormulaFields/formula_examples_dates.htm
All Answers
You have same solutions
https://help.salesforce.com/articleView?id=000004526&type=1
https://success.salesforce.com/answers?id=90630000000hWyVAAU
https://developer.salesforce.com/docs/atlas.en-us.usefulFormulaFields.meta/usefulFormulaFields/formula_examples_dates.htm
I am not sure if these formulae take the time factor into account. I will try them in the next couple of days and let you know how it goes.
Thank you for the taking the time and providing me this information.
Thank you!
Sugi
There are few complications/mis understandings behind the formula field to calculate the business hours, Since you're not concerned about the hours you can achieve this functionality with a Batch job which you can run on end of every day.
1) Add a record in Busines Hours : [ Setup >> Company Profile >> Business Hours ]
2) Query that record in Apex class based on those 2 dates and find out the differance.
with that you can easily grab the business days.
3) Schedule this job every end of the day.
Sathish P