function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shoshinsha81Shoshinsha81 

Formula Assistance

Need to create a formula checkbox to check if time of record creation is within business days  (Excluding weekends).

Business hours 8 am to 5 pm Central Time

Thanks in advance. 
GauravGargGauravGarg
Hi Shoshin,

First we need to calculate, whether record is created on Weekday or weekend. 

Please try below link for weekday calculation:
https://help.salesforce.com/HTViewSolution?id=000004526

Once, we get the record creation day, then we can setup a new formula for business hours accordingly.

Please setup weekday calculation and let us know for futher assistance. 

Thanks,
Gaurav
Email: gauravgarg.nmims@gmail.com