For those wondering why the TWC list didn't reset today (lol, yeah, like its ever reset exactly on time... :P), the SQL job I setup had a placeholder that I never had gone back in and replaced.  I have a bad habit of choosing reasonable placeholders, so I tend not to notice the fact that something is a placeholder instead of a real value.  The job was resetting the list to every vote after June 6th, which worked well in June, but obviously now that we are in July, not so much.

 

Placeholders.  I don't know how to work without them, I mean, I want to keep moving forward, and stay focused, so I just add in a quick placeholder, expecting one of the designers to replace it or something usually.  Unfortunately, I 've learned repeatedly that if the placeholder looks reasonable, the designers will craft the page using my placeholder pixel for pixel.  Which is always depressing because I usually had imagined something a bit cleaner, more professional, etc, which causes me to go back in later and fix it. 

I usually don't have a problem in my own code with placeholders, but this time it was something that worked perfectly for last month, now I've changed it to dynamically choose the first day of the month, should run fine.