convert date to Excel-format()
This function creates a text in Excel's internal date format from date a. b specifies if the text should contain time information.
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 |