Weekday Funktion in SIGNAL?

[niels1515]

Hi experts, I would like to design a widget that can measure the delivery reliability. I would like to add two working days to the goods receipt date so that we have a certain grace period.

Does anyone have an idea how I could implement this? I have already tried various SQL Weekday functions in Signal, but every time I get an error in Signavio. I assume this function does not exist in the SIGNAL language.

The bottom line is that I need a way to break down the date into days of the week in order to develop a WHEN query accordingly. Does Signal have such a function?

Regards
Niels

[daniel_hesseling]

Hi Niels,

you can use the DATE_PART function in SIGNAL to achieve this:

SELECT
    "case_id",
    DATE_PART('day_of_week', (SELECT FIRST("end_time"))) AS "Day of week"
FROM THIS_PROCESS

You just need to use the argument 'day_of_week', as you can see here: 
https://help.sap.com/docs/signavio-process-intelligence/signal-guide/date-part?locale=en-US