|
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.
|
ExamplesThe
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.
|
|
|
|
