|
Analyzes the given data according
to the given picture format.
Parsing data successfully results in one of the following values:
-
Date picture format: An ISO date string of the form YYYY-MM-DD.
-
Time picture format: An ISO time string of the form HH:MM:SS.
-
Date-time picture format: An ISO date-time string of the
form YYYY-MM-DDTHH:MM:SS.
-
Numeric picture format: A number.
-
Text pictures: Text.
Parameters
|
Parameter
|
Description
|
|
s1
|
A valid date or time picture format string.
For
more information on date and time formats, see
Date and Time Functions
.
|
|
s2
|
The string data to parse.
|
Examples
The
following expressions are examples that use the
Parse
function:
|
Expression
|
Returns
|
|
Parse("MMM D, YYYY", "Sep 1, 2002")
|
2002-09-01
|
|
Parse("$9,999,999.99", "$1,234,567.89")
|
1234567.89
in the U.S.
|
|
|
|
