Returns a Character-type date from a Date or DateTime expression.
DTOC(dExpression | tExpression [, 1]) |
Parameters
- 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:
В Copy Code INDEX ON DTOC(gdInvDate, 1) + gnInvTime TAG Timeindx
gdInvDate
andgnInvTime
are fields containing the date and time when the data was entered in the record.
Return Value
Character
Remarks
DTOC(В ) returns a character string corresponding to a Date or DateTime expression. The date format is determined by SET CENTURY and SET DATE.
Example
В | Copy Code |
---|---|
SET STRICTDATE TO 1 STORE CTOD('10/31/98') TO gdThisDate CLEAR ? DTOC(gdThisDate) STORE DTOC({^1998-10-31}+90) TO gcExpireDate ? 'Your 90-day warranty expires ', gcExpireDate ? DTOC({^1998-10-31},1) |