This function parses the content of a as Excel-internal date format.
If the text cannot be parsed, b specifies to next step to be taken.
Possible values for parameter b
Value | Behaviour of function |
|---|---|
now | The current date will be returned. |
empty | The Empty Flag is set. Internally, the field also receives the current date. However, because of the Empty Flag, the value is not visible. |
error | Finishes the function with an error. |
Other value | Instead of the input value, the given value will be interpreted as Excel-internal format instead. If that value cannot be parsed, either, the function will finish with an error. |
Parameters
Parameter | Description |
|---|---|
a | Text to be parsed. |
b | (optional) Default behaviour. Default: empty |
Examples
Parameter a | Parameter b | Result | Result of function “is empty(a)” |
|---|---|---|---|
abc | true | ||
abc | empty | (see description of empty for parameter b above) | true |
abc | now | Current date. | false |
abc | error | Function throws an error. | |
36526,5 | 2000-01-01 12:00:00.0 | false | |
abc | 41729,5743287037 | 2014-03-31 13:47:02.0 | false |
abc | cba | Function throws an error. |