convert date to Excel-format(date a, [skip time b])
|
Group |
Creates from date a a text in Excel's internal date format. b specifies if the text should contain time information.
Description of Parameters
|
Parameter |
Description |
|
a |
The date to be formatted. |
|
b |
(optional) true if the output should not contain the time information. Default: false. |
Examples
|
Parameter a |
Parameter b |
Result |
|
2014-03-31 13:47:02.0 |
41729,5743287037 |
|
|
2014-03-31 13:47:02.0 |
false |
41729,5743287037 |
|
2014-03-31 13:47:02.0 |
true |
41729 |
|
2000-01-01 00:00:00.0 |
false |
36526,0 |
|
2000-01-01 00:00:00.0 |
true |
36526 |