value( text, format )
Converts text representing a number into an actual number or datetime.
Keyword | Type | Description |
---|---|---|
|
Text |
The string of characters to be converted into a number or date. |
|
Text |
The input format of the value, such as "mm/dd/yyyy". |
Any Type
The text value checks for decimal points, slashes, hyphens, and colons to determine whether you are trying to have the function return a date or a number.
value("12/13/2005","mm/dd/yyyy")
returns 12/13/05 12:00 AM GMT