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"

Sample Actions 

Transform
My Action
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?