DATESBETWEEN Returns a table that contains a column of dates that begins with the start_date and continues until the end_date.
Dates – A reference to a date/time column.
Start_date – A date expression.
End_date – A date expression.
A table containing a single column of date values.