Skip to Content
avatar image
Former Member

Formarted search for service calls

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 30, 2015 at 08:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 09:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 09:46 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded