- ⌂ Variables
Output a date modified by a specified amount of days, months or years.
#ADJUSTDATE($date, $unit, $amount)
- date - A date value to be changed, such as '2004-12-20'.
- 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)
#* Advance date by two months to: 2005-02-20 *# #ASSIGN($Date, '2004-12-20') #ADJUSTDATE($Date, MONTH, 2)
#FORMAT can be used to format a date, time or timestamp.