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 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.

Noten cannot be higher than 50000.


Syntax
addDaysSkippingWeekends(number_1, number_2, time_zone)
Input data type(s)

status_name: TEXT
schedule_name: STRING
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.