• Date and Time Functions
  • ADDMONTH Function
  • ADDYEAR Function
  • Date and Time Functions
  • Day Function
  • DAYSTR Function
  • DMY Function
  • DTOS Function
  • FMTDATESTR function
  • ITOD Function
  • LDATE Function
  • MKDATE Function
  • MONTH Function
  • MONTHSTR Function
  • PERSTR Function
  • PERTOJ Function
  • SDATE Function
  • SDATETOJ Function
  • SYSDATE Function
  • SYSTIME Function
  • VERDATE Function
  • VERSION Function
  • VERTIME Function
  • YEAR Function

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.

Related Topics

• Date and Time Functions