DTTOD( )

Topic group Related topics

"DateTime to Date" converts the date component of a DateTime value to a literal Date .

Syntax

DTTOD(<dtVar>)

<dtVar>

A DateTime variable or value

Description

Use DTTOD( ) to convert the date component of a DateTime value into a literal Date. DTTOC( ) has no affect on the DateTime's time component. Where the current value of DATETIME( ) = 02/13/01 03:39:14 PM:

 d1=DATETIME()  

 d2=DTTOD(d1)

 ?d2      //Yields 02/13/01

SET DATE determines the order of the day, month, and year.

SET CENTURY determines whether the year is expressed as two or four digits.

SET MARK assigns the separator character.