DAYS_BETWEEN

Description

DAYS_BETWEEN takes a start date and an end date and returns the number of days between them.

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

Example

p is Person
DAYS_BETWEEN(p.date_of_birth, TODAY())

This returns the total number of days the person has been alive.

Example with named arguments

p is Person
DAYS_BETWEEN(start_date: p.contract_start, end_date: p.contract_end)