• 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

SDATE Function

The SDATE function takes the value entered in the brackets and evaluates it to the corresponding date, returning the date in a short date string. The format of the short date is based on the Regional Settings specified for your computer. Apply the SDATE function to cells that have been formatted as alphanumeric.

Syntax

SDATE(expression)

Example 1

SDATE(SYSDATE())

Returns the date specified in a short date format; for example, 14/02/06.

Example 2

SDATE(CLP13)

Returns the year-end date (as specified in the Engagement Properties) to a short string format; for example, 31/12/06.

Related Topics

• Date and Time Functions