This function returns the day of the week of any given timestamp.

Syntax
 dayOfTheWeek(timestamp, timeZone) #Output: Number
Examples
Parser expressionDescription
%{dayOfTheWeek({issue.dueDate},RUN_AS_LOCAL)}

This example will return the day part of the issue's due date. 

If the due date was set to April 21st, 2020 00:00 the output would be 3 since this day is a Tuesday.

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be a valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
timeZone

TEXT

The time zone used for the calculation. 

Days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

This function returns a NUMBER where Sunday = 1, Monday = 2, ... Saturday = 7.


Use cases and examples