Difference between revisions of "CTOD()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert character to date | Function to convert character to date | ||
| − | |||
==Syntax== | ==Syntax== | ||
CTOD(<expC>) | CTOD(<expC>) | ||
| − | |||
==See Also== | ==See Also== | ||
[[CDOW()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOC()]], [[DTOS()]], [[MDY()]], [[MONTH()]], [[SET DATE]], [[SET CENTURY]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]] | [[CDOW()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOC()]], [[DTOS()]], [[MDY()]], [[MONTH()]], [[SET DATE]], [[SET CENTURY]], [[STOD()]], [[TIME()]], [[WEEK()]], [[YEAR()]] | ||
| − | |||
==Description== | ==Description== | ||
The CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date. | The CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date. | ||
| − | |||
==Example== | ==Example== | ||
| Line 23: | Line 19: | ||
D | D | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 11:38, 11 December 2012
Purpose
Function to convert character to date
Syntax
CTOD(<expC>)
See Also
CDOW(), CMONTH(), DATE(), DAY(), DMY(), DOW(), DTOC(), DTOC(), DTOS(), MDY(), MONTH(), SET DATE, SET CENTURY, STOD(), TIME(), WEEK(), YEAR()
Description
The CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date.
Example
mdate = ctod("11/10/2003") ? mdate 11/10/2003 ? type("mdate") D
Products
Lianja Server, Lianja
