HOURS_BETWEEN

Description

HOURS_BETWEEN takes a start datetime and an end datetime and returns the number of hours between them.

You can pass the values positionally or using the named arguments start_date and end_date.

Example

p is Person
HOURS_BETWEEN(p.meeting_start, p.meeting_end)

This returns the duration of the meeting in hours.

Example with named arguments

p is Person
HOURS_BETWEEN(start_date: p.meeting_start, end_date: p.meeting_end)