TIMESTAMP equivalent of any given day plus an offset of n days where weekends don't count.
Syntax | addDaysSkippingWeekends(number_1, number_2, time_zone) |
---|---|
Input data type(s) |
|
Output | NUMBER |
Examples |
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Next »
TIMESTAMP equivalent of any given day plus an offset of n days where weekends don't count.
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.
Syntax | addDaysSkippingWeekends(number_1, number_2, time_zone) |
---|---|
Input data type(s) |
|
Output | NUMBER |
Examples |
Show examples
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. 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. 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. |
Powered by Atlassian Confluence 8.5.15, themed by Refined 7.6.0 and Decadis AG