How to get weekday value in entity filter?

support
1

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.

2

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

3

I would disagree a little.

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

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

4

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).