Links are not active on this page.
 DTOS( ) Function

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

DTOS(dExpression | tExpression)

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.

Expand imageReturn Value

Character

Expand imageRemarks

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.

Expand imageExample

 CopyCode imageCopy Code
CLEAR
? DTOS(DATE( ))

Expand imageSee Also