Formarted search for service calls
I want to achieve a due date on service calls using formarted search any one with an idea how to ? That is if the priority is high the due date is after a day, if the priority is medium the due date is after two days and if the priority is low then the due date is after three days.
Try this one.
SELECT case $[$42.0.0] when 'H' then $[$71.0.Date] +1
when 'M' then $[$71.0.Date] +2
when 'L' then $[$71.0.Date] +3 end