JavaScript Editor js editor     Web development 



Main Page

Converts a character expression to a date expression.

CTOD(cExpression)

Parameters

cExpression


Specifies a character expression.

Return Value

Date data type. CTOD( ) returns a Date value.

Remarks

Note:
CTOD() can create ambiguous Date values and generates a compilation error when SET STRICTDATE is set to 2. To create unambiguous Date values, use the DATE(В ) function.

Example

The following example uses CTOD( ) to convert Character data to a Date and then performs simple date related actions.

В Copy Code
SET CENTURY ON               && Shows the century value.
cDate="01/01/2003"
?CTOD(cDate)               && Returns 01/01/2003 as Date.
?GOMONTH(CTOD(cDate),12)   && Returns 01/01/2004.
?CTOD(cDate)+100            && Returns 04/11/2003.

See Also



JavaScript Editor js editor     Web development