You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

TIMESTAMP equivalent of any given day plus an offset of n days where weekends don't count.


Syntax
addDaysSkippingWeekends t, n, time_zone)

If represents a timestamp which coincides with a Friday, adding n = 1 will return a date-time for the following Monday.

Negative values for are used in order to subtract days to t.

(warning) Noten cannot be higher than 50000.

Input data type(s)

t: NUMBER representing a timestamp
n: NUMBER representing the number of days
time_zone: TIMEZONE

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.