1. Docs
  2. Formulas
  3. Functions

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

Categories: Dates/Times

Syntax

HOUR(date)

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"

Sample actions

Event Transform
My Action
Event Transform
HOUR

Select an action to inspect

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?