nextDayOfTheWeek()

Returns a NUMBER representing the timestamp for the next day of the week from dayOfWeek from timestamp t in a certain time_zone. The timestamp returned is at 00:00,

i.e., just the beginning of the day.

nextDayOfTheWeek(number t, number dayOfWeek, timeZone time_zone) #Output: Number

Examples

Parser expression	Description
nextDayOfTheWeek(2018/03/01 12:31, {SUNDAY}, LOCAL)	The function returns a NUMBER : `2018/03/04 00:00`. taking into account that 2018/03/01 is a Thursday.
nextDayOfTheWeek(2018/03/01 12:31, {THURSDAY}, LOCAL)	The function returns a NUMBER : `2018/03/08 00:00`

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`timestamp`	NUMBER	The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
`timeZone`	TIMEZONE	The time zone used for the calculation.

Work 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

The function returns a NUMBER

Content

Space Tools

Parameters used in this function