AUDIT DATE - Audit date (Reports & Settings Report Generator function)
From Catalyst
(Redirected from REF:rprgfaudit date)
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).
|
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.