Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)