|
Converts a date entered or stored as a character string to a Date value. The Data value is a numeric value that represents the number of days elapsed since the day before the first day of the 1st century (01/01/01) until the date that is being converted.
|
|
Syntax:
|
DVal(datestring, picture)
|
|
Parameters:
|
datestring: A character string or an alpha expression that can be interpreted as a date (e.g., '01/01/92', 'Jan 1, 1992').
|
|
|
picture: The format for datestring. This parameter is required for Magic xpa to read and interpret the character string or expression. For a full description, see pictures.
|
|
Returns:
|
Date value
|
|
Examples:
|
DVal('01/01/01','MM/DD/YY') and DVal('Jan 1, 2001','MMM D,YYYY') each returns '01/01/2001'Date
|
|
|
DVal(A,vMMMMMMMMM DD, YYYY') where variable A contains 'January 12, 2002' also returns '12/01/2002'Date
|
|
See also:
|
DStr
How Do I Calculate a Date Value that Is Stored in a String?
The Online and Rich Client Samples projects (program DT18 and RDT18)
|
