You need to sign in to do that
Don't have an account?
@ 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
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
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