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



Page properties
hiddentrue


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

Status
subtletrue
titletimestamp




UI Text Box
sizemedium
typeinfo

Returns a 

Status
subtletrue
titletimestamp
  resultant of adding n months to timestamp t.


UI Text Box
typetip

Use this function instead of simply adding n * {MONTH}, since {MONTH}is a macro equivalent to 30 * {DAY}. Negative values for n are used in order to subtract instead of adding.



Code Block
languagebash
titleSyntax
linenumberstrue
addMonths(timestamp, months, timeZone time_zone) #Output: Number 


UI Expand
titleExamples


Parser expressionDescription

addMonths(t, 3, LOCAL)




UI Text Box
typeinfo

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


This function returns a timestamp as a 

Status
subtletrue
titlenumber
with the value: June 25th, 25th 2011 23:15



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

Status
subtletrue
titlenumber

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

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


UI Text Box
typenote

In this function we are not taking into consideration the fact that some months have more or less than 30 days.