date-from-excel(text a, default b)
|
Group |
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. |
Description of 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. |