HOUR

Returns the hour of the day for the specified date. Accepted Formats: T17:49:01+0000, 17:49:01, or 2022-03-19T17:49:01+0000

Syntax 

HOUR(date)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": "2022-03-19T17:49:01+0000"
4
}
5
}

Formula

HOUR(my_action.message)

Output

"17"
Was this helpful?