Share via


DATEONLY (Report Builder 1.0)

Returns the year, month, and day from a datetime value.

Syntax

DATEONLY(datetime)

datetime

Specifies the datetime from which the day, month, and year are extracted.

Example

Formula

Result

DATEONLY(#5/31/2008 12:23:56 AM#)

5/31/2008 12:00:00 AM

DATEONLY(Sell Start Date)

Returns a date for each instance of the Sell Start Date field, similar to the following:

6/1/1998 12:00:00 AM

7/1/2001 12:00:00 AM

7/1/2002 12:00:00 AM

7/1/2003 12:00:00 AM