DTOS()

Convert a date value to a character string formatted as: yyyymmdd

Syntax

DTOS(<dDate>) --> cDate

Arguments

<dDate> --> is the date value to convert.

Returns

DTOS() returns a character string eight characters long in the form: yyyymmdd. When <dDate> is a null date (CTOD("")), DTOS() returns a string of eight spaces.

Description

DTOS() is a date conversion function that is used when sorting. DTOS() converts a date value to a character string that can then be joined to other character strings. Use this function when you wish to correctly sort date fields.

Examples

dDate := CTOD('01/02/03')

DTOS(dDate)

* Returns: 20030201

____________________________