Last updated: August 26, 2026.
The Hour function returns an integer from 0 through 23 representing the hour of a time value.
Syntax
Hour(time)| Argument | Description |
|---|---|
time | Date or time expression |
Examples
Hour(#2:30:00 PM#) ' 14
CreatedHour: Hour([CreatedAt])
CurrentHour: Hour(Now())A Null expression returns Null. Hour uses the time stored in the value; account for time zones before extracting reporting buckets.
See Microsoft’s Access function reference for related expression functions.
