AUDIT DATE - Audit date (Reports & Settings Report Generator function)

From Catalyst
Jump to: navigation, search

Syntax

$AUDIT_DATE{id, mode, N/T, CCYYMMDD}

Description

Return the audit date for a Data ID.

Parameters

id
A text parameter that can not be omitted.
Each Platinum file that is given the ability to store created/modified/used or viewed details (using the "Data ID" system) is given it's own 6 character "Data ID". This is stored on the file and can be reported on in the usual way by using a variable (see A54 for the Accounts File).
mode
A text parameter that can be omitted (it defaults to "C").
C
The created details of the record.
M
The modified details of the record.
U
The used details of the record.
This is not implemented for all files.
V
The viewed details of the record.
This is not implemented for all files.
N/T
A text parameter that can be omitted (it defaults to "N").
N
Numeric result. This is the number of days since the first of January 1980. This is most commonly used for sorting purposes.
T
Text result. This is the date formatted for display, e.g. '01/01/2004'. You can optionally use the next parameter to control the exact format.
CCYYMMDD
A text parameter that can be omitted (it defaults to "DD/MM/CCYY").
When the previous parameter is 'T', 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).
DD/MM/CCYY
Same as the default.
MM/DD/CCYY
Output in USA format.
CCYYMMDD
Use for sorting into date order (would have the same effect as using the numeric result).
CCYYMM
Use for grouping by month.


Returns

A text or numeric (depending on the parameters) value. The formatted created/modified/used or viewed date text.

See also

$DATE, $AUDIT_PROG, $AUDIT_SITE, $AUDIT_TERM, $AUDIT_TIME, $AUDIT_USER.

Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
date, day, month, year