Can I exclude a specific period of time from my report?

Return to top
Have more questions? Submit a request

1 Comments

  • Tobias Hermanns

    Hi LJ, 

    i want to exclude Lunch break 12:30 to 13:00 every day from report (Talk Dataset).

    I tried:

    IF DATE_FORMAT([Leg - Timestamp],"HH:MM") >= "12:30"
    AND DATE_FORMAT([Leg - Timestamp],"HH:MM") < "13:00"
    THEN "Exclude"
    ELSE "Include"
    ENDIF

     

    But so far it only not work, I only get "include" option.

    if I changed it to:

     

    IF DATE_FORMAT([Leg - Timestamp],"HH:MM") >= "12:00"
    AND DATE_FORMAT([Leg - Timestamp],"HH:MM") < "13:00"
    THEN "Exclude"
    ELSE "Include"
    ENDIF

     

    It works correctly with Include / Exclude

     

    How I can filter "mm" / Minutes correctly?

    Thanks.

    Tobias

    0

Please sign in to leave a comment.

Powered by Zendesk