Throwback Thursday: December 19, 2024
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.
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 Month
Some programming problems are difficult to solve. Others are difficult to solve clearly.
Mike Wolfe
Looping by Month: DateSerial
The first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().
Mike Wolfe
Creating a Monthly Lookup Table
Having a table where each record represents a single month can come in quite handy. Let’s create such a table.
Mike Wolfe
Looping by Month: Lookup Table
Have 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.
Mike Wolfe
Looping by Month: Loop Until with DateAdd
Reader Francesco Foti writes in with his own solution to the Looping by Month challenge.
Mike Wolfe
Wisdom from Around the Web
Brent Ozar: Date Table Fan
Brent 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.
Mike Wolfe
Developer Humor
Historical Dates
Cover image generated by Ideogram
