+ Start a Discussion
@ M  Coder@ M Coder 

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)
VinayVinay (Salesforce Developers) 
Hi,

Review below links that can help you.

https://success.salesforce.com/answers?id=90630000000gtCUAAY
https://success.salesforce.com/answers?id=9063A000000iXTlQAM

Thanks,
Vinay Kumar