HOUR

This function returns just the hour from a date time field.

HOUR( <date_field or date> )
  • date_field or date: A date field or value.

Example: Create a field on the ISSUE table that gives the hour that an issue was fixed.

HOUR( [ISSUE.Done Date And Time] )