Versions Compared

Key

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

...

Table plus

...

...

applyColStyleToCelltrue
heading0
columnTypess,s,s,

...

s
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,

...

...

enableSorting

...

<col style="width: 76.0px;" />
<col style="width: 410.0px;" />
<col style="width: 99.0px;" />
<col style="width: 141.0px;" />

...

false

Syntax

addMonths(date, noMonths)

...

Package

Alias

Pkg Usage

Description

Excerpt
hiddentrue
Adds a number of months to a specified date, preserving the day of month where possible.

</ac:rich-text-body>
</ac:structured-macro>
<p>Adds Adds a number of months to a specified date, preserving the day of month where possible.</p>
<h2>Parameters</h2>
<ac:structured-macro ac:name="table-plus" ac:schema-version="1" data-layout="default">
<ac:parameter ac:name="applyColStyleToCell">true</ac:parameter>
<ac:parameter ac:name="columnTypes">s

Parameters

Table plus
applyColStyleToCelltrue
columnTypess,s,s,

...

s
heading0
multiplefalse
enableSortingfalse

Parameter name

Type

Required

Description

date

Date

Yes

Specifies a Date expression.

noMonths

Number

Yes

Number of months to add. If given a negative number, will do subtract.

...

<h2>Example</h2>

...

Return Type

Date

Example

Code Block
languagejs
function addMonthsInDesc(date d, int noMonths){
    desc += "Date " + d + " + " + noMonths + " months = " + addMonths(d, noMonths) + "\n";
}
desc = "";
addMonthsInDesc("2012-01-31", 1);

...


addMonthsInDesc("2012-04-30", -2);

...


addMonthsInDesc("2013-01-31", 1);

...


addMonthsInDesc("2013-04-30", -2);

...


addMonthsInDesc("2012-01-31", 12);

...


addMonthsInDesc("2012-01-31", -1);

...

Outputs to description:</p><p>Date

Date 2012-01-31 00:00:00 + 1 months = 2012-02-29 00:00:00</p><p>Date 00

Date 2012-04-30 00:00:00 + -2 months = 2012-02-29 00:00:00</p><p>Date 00

Date 2013-01-31 00:00:00 + 1 months = 2013-02-28 00:00:00</p><p>Date 00

Date 2013-04-30 00:00:00 + -2 months = 2013-02-28 00:00:00</p><p>Date 00

Date 2012-01-31 00:00:00 + 12 months = 2013-01-31 00:00:00</p><p>Date 00

Date 2012-01-31 00:00:00 + -1 months = 2011-12-31 00:00:00</p><h2>See also</h2>
<p><ac:structured-macro ac:name="contentbylabel" ac:schema-version="4" data-layout="default">
<ac:parameter ac:name="showLabels">false</ac:parameter>
<ac:parameter ac:name="max">25</ac:parameter>
<ac:parameter ac:name="showSpace">false</ac:parameter>
<ac:parameter ac:name="cql">label 00

See also

Filter by label (Content by label)
showLabelsfalse
max25
showSpacefalse
cqllabel = "date_routine" and space = currentSpace ( )
</ac:parameter>
<ac:parameter ac:name="labels">array_routines</ac:parameter>
</ac:structured-macro></p>
labelsarray_routines

We've encountered an issue exporting this macro. Please try exporting this page again later.