DTOS( ) Function

Example   See Also

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

Syntax

DTOS(dExpression | tExpression)

Returns

Character

Arguments

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.