Returns a Character-type date from a Date or DateTime expression.
Syntax
DTOC(dExpression | tExpression [, 1])
Returns
Character
Arguments
dExpression
Specifies a Date-type variable, array element, or field for which DTOC( ) returns a Character-type date.
tExpression
Specifies a DateTime-type variable, array element, or field for which DTOC( ) returns a Character-type date.
1
Returns the date in a format suitable for indexing. This is particularly useful for maintaining the table records in chronological sequence.
For example, to order table records in entry sequence, you could issue this command:
INDEX ON DTOC(gdInvDate, 1) + gnInvTime TAG Timeindx
gdInvDate and gnInvTime are fields containing the date and time when the data was entered in the record.
Remarks
DTOC( ) returns a character string corresponding to a Date or DateTime expression. The date format is determined by SET CENTURY and SET DATE.