You are here: Help Topics > Customization > Calculation > SDATE 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