X06 - Transaction Date (Accounts Report Generator variable)

From Catalyst
Revision as of 05:31, 14 September 2018 by ThrashBot (talk | contribs) (Updated from revision control)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Syntax

X06{N/T, CCYYMMDD}

Description

Each transaction is given a date by the user when entered. This is not the actual date the transaction was posted but is the date used for accounting purposes.

Parameters

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 whose typical size is 10 characters.

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