Difference between revisions of "CTOD()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to convert character to date
 
Function to convert character to date
Line 28: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:25, 27 November 2009

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

Recital Server, Recital