Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page properties
hiddentrue



Status
Tech review

Status
titletodo

Style guide

Status
titletodo

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



Output
Page properties
hiddentrue


Short description
Timestamp equivalent of any given day plus an offset of n days where weekends don't count.

Returns a

Status
subtletrue
titlenumber
representing the month of a timestamp t in a certain time_zone, with January=1, ..., December=12.

Output

Status
subtletrue
titlenumber




UI Text Box

The function returns a

Status
subtletrue
titlenumber
representing the month of a timestamp t in a certain time_zone, with January=1, ..., December=12.


Code Block
languagebash
titleSyntax
linenumberstrue
month(number t, timeZone time_zone) #Output: Number


UI Expand
titleExamples


Parser expression Description


Code Block
languagebash
linenumberstrue
month(t,LOCAL)


UI Text Box
typeinfo

timestamp t has the value March 25th, 2011 23:15


The function returns a

Status
subtletrue
titlenumber
: 3 for March. represented also by macro {MARCH}



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

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

Status
subtletrue
titletimezone

The time zone used for the calculation. 

Expand
titleLearn more about timezones

Excerpt Include
Dates, times and time zones
Dates, times and time zones
nopaneltrue



UI Text Box
typetip

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. 



UI Expand
titleOutput

The function returns a

Status
subtletrue
title

number

Number