Great "Decoder" post. Thanks for taking the time to put it together, Steve. You're the best!
Joining in the "Decoder" fun, decode this. 😀 Folks like Lynn Pettis will have no problem.
Same possible answers the you posted in your question...
SELECT [Whatzit???] = DATEADD(dd,DATEDIFF(dd,-53690,DATEFROMPARTS(DATEPART(yy,GETDATE()),5,31))/7*7,-53690);
For those that want a bit more fun, if you know me, you already know the answer.
SELECT [Whatzit???] = DATEADD(dd,DATEDIFF(dd,-53690,DATEFROMPARTS(1900+t.N,5,31))/7*7,-53690)
Remembering the day...
Thank you to all my comrades in arms, whether you served, are currently serving, and especially to those that made the ultimate sacrifice. Thank you to all the loved ones that miss those serving and all those that can only remember now that they're gone. My thoughts are with you and them today and most every day.
And a special call out to Lynn Pettis... he was writing SQL while he served in harms way. IIRC, he was a civilian employee at the time but he was still "over der" helping out.
Jeff Moden STS1(SS)
U.S.N 17 Sep 71 - 06 Mar 80