Difference between revisions of "DATE - Format a date (Reports & Settings Report Generator function)"
From Catalyst
(Updated from revision control) |
|||
| Line 32: | Line 32: | ||
The formatted date text. | The formatted date text. | ||
| − | [[Category:Reports & | + | [[Category:Reports & Settings Report Generator functions]] |
Latest revision as of 13:03, 22 September 2016
Syntax
$DATE{date, type, format}
Description
Calculate a full date string formatted if required.
Parameters
- date
- A numeric parameter that can be omitted.
- Input date. If omitted, the current machine date is used.
- type
- A text parameter that can be omitted (it defaults to "S").
- S
- Short (eg. 11/09/1996).
- L
- Long (eg. Wednesday, 11th September 1996).
- format
- A text parameter that can be omitted (it defaults to "DD/MM/CCYY").
- When the previous parameter is 'S' (short), this parameter can be used to control the exact format. The following four values can be combined in any order, with separating characters if required.
- DD
- Day (01 to 31).
- MM
- Month (01 to 12).
- CC
- Century (19 or 20).
- YY
- Year (00 to 99).
Returns
A text value. The formatted date text.
