Excel stores dates as numeric serial values. The ExcelDate() function converts an Excel numeric date into a standard date format.

This function is primarily used during data interchange between Quintessence and Excel, ensuring that dates transferred between the two systems are interpreted as dates rather than numeric values.

Related functions: TypeCast

Syntax:

ExcelDate(NumericDate)

• In the Quintessence Editor (Studio) using Python language, use: Qx.ExcelDate()

Remarks:

• The need for this function has largely been replaced by the TypeCast() function, which can perform the same conversion.

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

return := ExcelDate(42005.9);