MKDATE Function
The MKDATE function converts an integer format to a date format. The MKDATE function should only be applied to cells that have been formatted as alphanumeric or date.
Syntax
MKDATE(expression)
Example 1
MKDATE(SYSDATE())
Converts the current system date in a string format. Therefore, if the system date were 01/01/07 this would be converted to January 1, 2007.
Example 2
MKDATE(CLP13)
Returns the year-end date of the client file in a string format. If the year-end date of the client file is 12/31/07, then December 31, 2007 appears in an alphanumeric cell.