date-from-excel()
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. |
|