MONTHINTERVAL

Creates a date interval between months.

Parameter List

Syntax
MONTHINTERVAL(startmonthendmonth
[startyear]
[endyear]
)
startmonth

Number of the starting month as number between 1 and 12. For example: 3.

endmonth

Number of the ending month as number between 1 and 12. For example: 8.

[optional] startyear

Year in which the interval should start. For example: 2020.

[optional] endyear

Year in which the interval should end. For example: 2021.

Examples

MONTHINTERVAL(1, 10) returns [2022-01-01; 2022-10-31]