webCOMAND

#ADJUSTDATE

Syntax

#ADJUSTDATE(Date,Unit,Amount)

Parameters

  • Date - A date value to be changed
  • Unit - The unit specifies which part of the date to change (DAY, MONTH, YEAR)
  • Amount - The amount of units to change the date by (-4 would adjust the date 4 MONTHs back)

Description

Output a Date modified by a specified amount of days, months or years (unit).

This statement produces output.

Related

#FORMAT can be used to format a date, time or timestamp.

#PHP can be used in combination with PHP Date/Time Functions.

Example

Here we will increase the month from December to February.

#NEW($Date)2004-12-20#ENDNEW
#ADJUSTDATE($Date,MONTH,2)

Result

2005-02-20

Analysis

In this example, the variable $Date is set to December 20th, 2004.  The #ADJUSTDATE block outputs $Date adjusted 2 months forward in time, resulting in February 20th, 2005.