| Description |
DVal (Magic xpa 2.x)
|
Converts a date entered or stored as a character string to a numeric value. The numeric value 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:
|
Number
| |
Examples:
|
DVal('01/01/97','MM/DD/YY') and DVal ('Jan1,1997','MMM D, YYYY') each returns 729025
| |
|
DVal(A,'MMMMMMMMM DD, YYYY') where variable A contains 'January 1,1997' also returns 729025
| |
|
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)
|
|
|
|---|
