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 |