DATEINTERVAL

Create a date interval between two dates.

Syntax

DATEINTERVAL(start, end)

start

The start date of the interval. For example, 2021-02-01.

end

The end date of the interval. For example, 2021-03-01.

DATEINTERVAL("2018-12-20", "2019-12-20") returns [2018-12-20;2019-12-20]