Learn why you shouldn't use BETWEEN for date range queries, even with the date data type.