DATEONLY (Report Builder)
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 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)