Skip to main content
Question

Extract day of the week or holiday from datetime

  • February 9, 2023
  • 1 reply
  • 12 views
F
Level 5

Hi all, I need to filter some instances occurred on sunday and on holiday. Is there a PQL function that can help me out?

Something like this:

CASE WHEN DAY_OF_THE_WEEK("EVENTTIME") = 'Sunday' or HOLIDAY("EVENTTIME") = 1 THEN "ID" ELSE NULL END

 

Thanks!

 

EDIT: Solved the day of the week part, still missing the holiday one

    1 reply

    G
    Level 12

    To know the day of week:

     

    https://docs.celonis.com/en/day_of_week.html

     

    To check in a Calendar I guess:

    https://docs.celonis.com/en/in_calendar.html

     

    and maybe some others, depending the specifics.

     

    HTH

    Community Code of ConductAccessibility statement