dayOfTheMonth()

The function returns the NUMBER of the day of the month in a timestamp represented by the numeric value t, in a certain time_zone.

Syntax

 dayOfTheMonth(number t, timeZone time_zone)

Parser expression	Description
dayOfTheMonth(t, LOCAL) timestamp has the value March 25th, 2011 23:15	The function returns a NUMBER: 25

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

numberOfDays

NUMBER

The number defined here will be the offset in days.

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro {DAY} to add full days to the timestamp. Learn more about time macros.

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.

The function returns a NUMBER