DATE - Format a date (Reports & Settings Report Generator function)
From Catalyst
Revision as of 11:37, 22 September 2016 by Les Ward (talk | contribs) (Les Ward moved page DATE - Format a date (Reports & Parameters Report Generator function) to DATE - Format a date (Reports & Settings Report Generator function))
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.