Jeff Moden (5/28/2015)
If you think you're embarrassed about "silly mistakes", then I'm totally humiliated by what your good post just reminded me of. I had totally forgotten about how DATEDIFF handles weeks differently than weeks and days of the week are handled by things like DATENAME and DATEPART. I think that part of the reason I forgot is because I had gotten into the habit of doing the days/7*7 thing but still no excuse for forgetting especially since my very first article on this site relied heavily on DATEDIFF(wk,,).
Thanks for that! I suppose if even you sometimes forget such things, then perhaps there is hope for me yet. 🙂
Cheers!