• 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

ITOD Function

The ITOD function converts an integer format to date format.

Syntax

ITOD(expression)

Remarks

The ITOD function should only be applied to cells that have been formatted as alphanumeric or date.

Example 1

ITOD(SYSDATE())

Returns 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

ITOD(CLP13)

Returns the year-end date (as specified in the Engagement Properties) in date format. In an alphanumeric cell, the date will be converted to string format. Therefore, if the year-end date is 12/31/07, the cell displays December 31, 2007.

Related Topics

• Date and Time Functions