• Date and Time Functions
  • Date and Time Functions
  • ADDMONTH function
  • ADDYEAR function
  • 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