TIMESTAMP equivalent of any given day plus an offset of n days where weekends don't count.
Syntax
addDaysSkippingWeekends t, n, 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.
Input
| Parameter | Data type | Description |
|---|---|---|
t |
| timestamp returned by a custom field or |
n |
| Number of days to be added n cannot be higher than 50000. |
time_zone |
| Timezone which will be used to base the calculation on |
Output
This expression will return a timestamp as a 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. |
| Syntax | addDaysSkippingWeekends t, n, 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.
|
|---|---|
| Input data type(s) |
|
| Output | NUMBER |
| Examples |
Note: n cannot be higher than 50000.