How to get weekday value in entity filter?

What is the easiest way to compute a weekday value of a datetime column in an entity filter? I can’t find such a function in the list of functions.

There is no built-in function so far. But you can create a custom database function.

I would disagree a little.

There is dates and times extension implemented into Origam XSLT transformation engine. You can easily use function date:day-in-week(). Check for detailed description.

Notice, that first day in a week in this function is Sunday. :smiley:

Good point. Nevertheless, this is only valid for XSLT transformations. I think the original question was about modeling entity filters (resulting in a pure SQL statements, so no XPath).