Daffodil Computers Ltd.
Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:22:52 PM
-
Function: Hour()
Purpose: The Hour() function converts a numeric or string expression containing a time value into an integer between 0 and 23 representing the hour of the day within that time value.
Usage: Hour(time)
Time is a numeric or string value representing a time.
Returns: Whole number between 0 and 23 representing the hour of the day.
Example
Hour("2:14:42 PM") = 14