6 Replies Latest reply on Jul 17, 2018 7:36 AM by Rochelle Williams

    Conditional format using a max time calculated filed

    Rochelle Williams

      I am trying to create a conditional format using a time field. This is my calculation for the conditional format. I'm getting the error "Expected THEN to Match IF at Character 0". not sure what it means.


      IF (DATEPART(MINUTE, [Max Wait Time])) between 00:05:00 and 00:09:59 THEN "Yellow"

      ELSEIF (DATEPART(MINUTE, [Max Wait Time])) >= 00:10:00 THEN "Red"

      ELSE "Black"