Extract day of the week or holiday from datetime

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

Page 1 / 1

To know the day of week:

To check in a Calendar I guess:

and maybe some others, depending the specifics.

HTH

Sign up