What do BETWEEN and the devil have in common?

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