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.