MTOD()

From Recital Documentation Wiki
Revision as of 17:14, 3 December 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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