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.
Return Value
Character
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
Copy Code | |
|---|---|
CLEAR ? DTOS(DATE( )) | |
Microsoft Visual FoxPro 9 SP2 Help file, VFPX Edition v1.08