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.

Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.

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

HOUR( [ISSUE.Done Date And Time] )