92 Replies Latest reply: Mar 1, 2017 8:55 AM by victor onyebuchi RSS

    What NOW() function will output??

    victor onyebuchi

      stalwar1s@@@@@who knows what the now function used below in my expression will produce??

       

       

       

      IF(TICKET_STATUS = 'WORK IN PROGRESS' OR TICKET_STATUS='HOLD' OR TICKET_STATUS='ASSIGNED' OR TICKET_STATUS='NEW',

      IF(TIER='GOLD' AND NOW()>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA'),

      IF(TIER='SILVER',

      IF(DECODE_PRIORITY ='High' AND (NOW()+2)>RESOLVE_BEFORE,'OUT_OF_SLA',

      IF(DECODE_PRIORITY='Medium' AND (NOW()+7)>RESOLVE_BEFORE,'OUT_OF_SLA',

      IF(DECODE_PRIORITY='Low' AND (NOW()+10)>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA')))))

       

       

      I want the number(2) in  (NOW()+2) to be in DAYs and not HOURS??

      e.g NOW()+2DAYS