SOS! Need help writing the syntax for a workflow. I made a custom field “lead time” with drop down options of “2-4 weeks”, “4-6 weeks”, etc etc and need to create syntax that calculates a date in “end date” field when an option is selected
End Date=CASE WHEN ({custbody_leadtime} IS ‘2-4 Weeks’ THEN {enddate} IS to_date({trandate}) + 28 END ELSE CASE WHEN {custbody_leadtime} IS ‘4-6 Weeks’ THEN {enddate} IS to_date({trandate}) + 42 END ELSE CASE WHEN {custbody_leadtime} IS ‘8-10 Weeks’ THEN {enddate} IS to_date({trandate}) + 70 END ELSE CASE WHEN {custbody_leadtime} IS ’10-12 Weeks’ THEN {enddate} IS to_date({trandate}) + 74 END ELSE WHEN {custbody_leadtime} IS ’12-14 Weeks’ THEN {enddate} IS to_date({trandate}) + 98 END