Use BETWEEN keyword with caution when comparing dates

TL;DR If you’re filtering results with a clause involving a date column being between two given dates, it can be safer to define the clause as I discovered an interesting trap the other day when diagnosing an issue where an SSRSSQL Server Reporting Services report was…