Nestor Vergano

Hi!

I'm trying to identify those tickets that had been received before the end of the the day (Mon-Fri before 18:00) BUT had been left over (from New to Open) till the next day.

This is the script I wrote, but an error "There's an issue with the formula..." appears with no more precise info. The highlighted code is the one that brings the formula error, and I don't understand why.

Please Help! Thanks in advance

IF (IN([Ticket created - Day of week],ARRAY("Monday", "Tuesday","Wednesday","Thursday","Friday"))
    AND IN([Ticket created - Hour],ARRAY(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)))
THEN IF ([Ticket created - Date] != [Ticket first assigned - Date])
            THEN TRUE
            ELSE FALSE
ELSE FALSE
ENDIF

Hola, Cuento con una suscripción Professional y necesito ayuda para poder configurar un reporte de Explore que me muestre todos los tickets recibidos en horario laboral (New) pero que no fueron tomados por un agente hasta el día siguiente.
Muchas gracias.