Home > Expression Operators > Date Operators > Duration

Duration

A period of time, specified as a number of years, months, and days.

Syntax:

yearsy monthsm daysd

Capitalization is ignored.

Examples:

3y2m15d equals 3 years, 2 months and 15 days

15y equals 15 years

36m equals 36 months

15d equals 15 days

Durations can be scaled up by multiplication. If the field SERVICE contains the value 22.5, then (1y * SERVICE) returns 22.5 years.