> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: March 26, 2026
- URL: https://nolongerset.com/throwback-thursday-2026-03-26/
- Published: 2026-03-27T00:30:04.000Z
- Updated: 2026-05-08T12:48:46.000Z
- Description: In today's edition of Throwback Thursday, we review some common gotchas of the SQL BETWEEN statement and how to avoid falling victim to these potential logic errors.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.*

*That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.*

---

## Highlights from NoLongerSet.com

[Beware the BETWEENUsing the BETWEEN clause with date-time fields may lead to unexpected results. There’s a safer alternative.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/10/pumpkin-4597886_1920.jpg)](https://nolongerset.com/beware-the-between/)

[3 Gotchas of the SQL BETWEEN StatementThe SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/12/petronas-911580_1920.jpg)](https://nolongerset.com/gotchas-of-the-sql-between/)

[A Safer Alternative to BETWEEN When Filtering DatesThis convenient function generates defensive SQL statements to help you avoid the subtle dangers of the BETWEEN statement when filtering dates.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/12/architecture-3223843_1920.jpg)](https://nolongerset.com/betweendates/)

## Wisdom from Around the Web

[Microsoft Access tips: International Dates in AccessHow to ensure dates are interpreted correctly in a Microsoft Access database, even when the user’s regional settings are different from the US format.![](http://allenbrowne.com/favicon.ico)](http://allenbrowne.com/ser-36.html)

[Examples of using dates as criteria in Access queries - Microsoft SupportWhen entering dates as query criteria, enclose them in pound signs (#) to help Access understand what they are.![](https://support.microsoft.com/apple-touch-icon.png)Microsoft Support![](https://support.microsoft.com/images/Facebook-GrayScale.png)](https://support.microsoft.com/en-us/office/examples-of-using-dates-as-criteria-in-access-queries-aea83b3b-46eb-43dd-8689-5fc961f21762)

## 

*Cover image generated by Ideogram*