Returns the NUMBER of days in the month of timestamp t, in a certain time_zone.
daysInTheMonth(number t, timeZone time_zone) #Output: Number
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 5 Next »
Returns the NUMBER of days in the month of timestamp t, in a certain time_zone.
daysInTheMonth(number t, timeZone time_zone) #Output: Number
Parser expression | Description |
---|---|
daysInTheMonth(2016/02/28 00:00, LOCAL) | The function will return a NUMBER: 29 2016 was a leap year. |
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.
The function returns a NUMBER.
Powered by Atlassian Confluence 8.5.7, themed by Refined 7.5.3 and Decadis AG