Difference between revisions of "MTOD()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to convert a date string in the format DD-Mmm-YYYY to a date data type | Function to convert a date string in the format DD-Mmm-YYYY to a date data type | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[AMPM()]], [[CDOW()]], [[CTOD(),CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[MONTH()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[STOD()]], [[TIME()]], [[VTOD()]], [[YEAR()]] | + | [[AMPM()]], [[CDOW()]], [[CTOD()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[MONTH()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[STOD()]], [[TIME()]], [[VTOD()]], [[YEAR()]] |
| Line 29: | Line 25: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 17:14, 3 December 2009
Purpose
Function to convert a date string in the format DD-Mmm-YYYY to a date data type
Syntax
MTOD(<expC>)
See Also
AMPM(), CDOW(), CTOD(), CMONTH(), DATE(), DAY(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), MDY(), MONTH(), SET CENTURY, SET DATE, SET MARK, STOD(), TIME(), VTOD(), YEAR()
Description
The MTOD() function is used to convert date strings in the format DD-Mmm-YYYY to date data types. The returned date will be in the format determined by SET CENTURY, SET DATE and SET MARK.
If <expC> is not a valid date string, MTOD() will return an empty date. The DD-Mmm-YYYY format is the calendar date format in Recital Mirage.
Example
set century on ? mtod("10-Oct-2008") 10/10/2008
Products
Recital, Recital Server
