Maybe this one…
So, I’ll explain the logic a little bit. My main goal was to try to get the 1st day of the month, but two months from now. So for example, today is January 22nd. My goal was to figure out March 1st, and then simply subtract 1 day to get the last day of the previous month.
If you look at the formula, I am first taking today’s date, and subtracting the number of days from that same date. Technically that gives me December 31st as a result, but then I add 15 days. The reason I add 15 days is…
Actually, from the same thread… I think this was the very first time Jeff Chuck unleashed the magic 15. I’ll never forget it. He did in one column what had taken me more than 40 columns
And, if you like date related stuff, have a browse through this thread…
I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now.
Working on these posts re-triggered this memory.
What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te…
2 Likes
