Salesforce

DVal (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

DVal (Magic xpa 4.x)

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)

Reference
Attachment 
Attachment