Formarted search for service calls

[Former Member]

Hi,

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.

Please help.

[Former Member · Accepted solution]

Hi Timothy,

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

[Former Member]

Thanks

[Former Member]

check with this

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