Apex Code Development You need to sign in to do that
Don't have an account?
Business hours formula field
Hello Folks ,
I have a requirement where i need to write a formula field in workflow based on below scenario.
part 1:My office hours are from 9AM to 6PM .
part2: apart from these hours any New lead created , i want to assign alead owner to a queue (This we can do via a field update).
solution i need is for part 1 , how to write a formula for creating a new lead other than office hours and weekends to trigger my wf rule .
can any one please help.
My formula criteria should be like :
AND (ISPICKVAL(Status, "New"), time should not be in between 9 AM to 6PM)
I have a requirement where i need to write a formula field in workflow based on below scenario.
part 1:My office hours are from 9AM to 6PM .
part2: apart from these hours any New lead created , i want to assign alead owner to a queue (This we can do via a field update).
solution i need is for part 1 , how to write a formula for creating a new lead other than office hours and weekends to trigger my wf rule .
can any one please help.
My formula criteria should be like :
AND (ISPICKVAL(Status, "New"), time should not be in between 9 AM to 6PM)
Review below links that can help you.
https://success.salesforce.com/answers?id=90630000000gtCUAAY
https://success.salesforce.com/answers?id=9063A000000iXTlQAM
Thanks,
Vinay Kumar