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. |