ExcelDate
Excel stores dates as numeric values. The ExcelDate() function converts an Excel numeric date to a standard date format.
This is used during data interchanges between Quintessence and Excel, so that dates passed from Excel to Quintessence and back will automatically be formatted as dates and not numbers.
Note:
The need for this function has fallen away since the implementation of the TypeCast() function which can achieve the same result.
Syntax
ExcelDate (NumericDate)
| NumericDate | An Excel date formatted as a number |
Examples
| Function | Output |
| ExcelDate(42005) | 2015/01/01 12:00:00 AM |
| ExcelDate(41917) | 2014/10/05 12:00:00 AM |
| ExcelDate(36441) | 1999/10/08 12:00:00 AM |
| ExcelDate(0) | 1899/12/30 12:00:00 AM |
| ExcelDate(99999) | 2173/10/13 12:00:00 AM |