+ Start a Discussion
@ M  Coder@ M Coder 

Issue with My formula field !!!! Please correct

I want my workflow rule to fire based on below criteria. 
Scenario : User on  creation of case with type "Mechanical" and created time should NOT be in between  10 AM to 6 PM.  in other than above mentioned hrs i have a wf field update which will fire. I am stuck with rule how to fire .

My formula: 
ISPICKVAL( Type ,'Mechanical') && (VALUE(MID(TEXT(CreatedDate+ 0.2208),12,2))  <10.00 && VALUE(MID(TEXT(CreatedDate+ 0.2208),12,2)) < 22.00)

if i create a case at 11pm , we get VALUE(MID(TEXT(CreatedDate+ 0.2208),12,2) = 23. 

can you please correct my formuale
VinayVinay (Salesforce Developers) 
Hi,

You cannot use formula field value to trigger workflow.

Review below idea link for the same.

https://trailblazer.salesforce.com/ideaview?id=08730000000BrIGAA0

Try using a process builder.

Thanks,
Vinay Kumar