> ## 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: December 19, 2024
- URL: https://nolongerset.com/throwback-thursday-2024-12-19/
- Published: 2024-12-20T00:32:32.000Z
- Updated: 2026-05-08T12:43:05.000Z
- Description: How do you loop by month in VBA? Coding it clearly is surprisingly difficult. We explore several approaches in today's edition of Throwback Thursday.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*With over a million words scattered across more than 1,300 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

[Sticky Wicket: Looping by MonthSome programming problems are difficult to solve. Others are difficult to solve clearly.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/county-cricket-2639131_1920.jpg)](https://nolongerset.com/sticky-wicket-looping-by-month/)

[Looping by Month: DateSerialThe first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/agenda-1928419_1920.jpg)](https://nolongerset.com/looping-by-month-dateserial/)

[Creating a Monthly Lookup TableHaving a table where each record represents a single month can come in quite handy. Let’s create such a table.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/calendar-5606_1920.jpg)](https://nolongerset.com/creating-a-monthly-lookup-table/)

[Looping by Month: Lookup TableHave I ever used this method? No. Can I imagine a situation where it could be useful? Maybe. Should I write an article about it? Sure, why not.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/calendar-547619_1920.jpg)](https://nolongerset.com/looping-by-month-lookup-table/)

[Looping by Month: Loop Until with DateAddReader Francesco Foti writes in with his own solution to the Looping by Month challenge.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/motor-loop-3260697_1920.jpg)](https://nolongerset.com/looping-by-month-loop-until-with-dateadd/)

## Wisdom from Around the Web

[Brent Ozar: Date Table FanBrent Ozar, legendary SQL Server guru, makes his case for using a “Date Table.” The video is all done in T-SQL, but the concepts apply equally to ACE backends.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/03/2021-03-01-21_20_05-mjw20-Window.png)](https://nolongerset.com/brent-ozar-date-table-fan/)

## Developer Humor

### Historical Dates

[![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2024/12/image-22.png)](https://www.xkcd.com/2676/)

Evidence suggests the 1899 transactions occurred as part of a global event centered around a deity associated with the lotus flower.

*Cover image generated by Ideogram*