Share via

DTOS( ) Function

  • Article

Returns a character-string date in a yyyymmdd format from a specified Date or DateTime expression.

DTOS(dExpression | tExpression)

Return Values

Character

Parameters

  • dExpression
    Specifies the Date expression DTOS( ) converts to an eight-digit character string.
  • tExpression
    Specifies the DateTime expression DTOS( ) converts to an eight-digit character string.

Remarks

This function is useful for indexing tables on a Date or DateTime field. It is equivalent to DTOC( ) when its optional 1 argument is included.

The character string returned by DTOS( ) isn't affected by SET DATE or SET CENTURY.

Example

CLEAR
? DTOS(DATE( ))

See Also

DATE( ) | DATETIME( ) | CTOD( ) | DTOC( )