TIMESTAMP equivalent of any given day plus an offset of n days where weekends don't count.
Syntax | addDaysSkippingWeekends(timestamp, days, time_zone) If t represents a timestamp which coincides with a Friday, adding n = 1 will return a date-time for the following Monday. Negative values for n are used in order to subtract days to t. Note: n cannot be higher than 50000. Example timeInStatus("Open", "my_schedule", LOCAL) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Input data type(s) | s
s | ||||||||||||
Output | NUMBER |
Examples
Parser expression | Description |
---|---|
timeInStatus("Open", "my_schedule", LOCAL) | Number of milliseconds the current issue has stayed in status "Open" within the schedule called "my_schedule" matching the server's default timeZone. |
s |
s