DATE - Format a date (Reports & Settings Report Generator function)

From Catalyst
(Redirected from REF:rprgfdate)
Jump to: navigation, search

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.