HOUR (Report Builder)
Extracts the hour from a datetime.
Syntax
HOUR(datetime)
datetime |
Specifies the datetime from which the hour is extracted. |
Example
| Formula | Result |
|---|---|
HOUR(#7/15/2006 3:30:29 AM#) |
3 |
HOUR(NOW( )) |
Returns the hour of the day at the time the report is run. |
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)