Just a clarification for others reading this, single quotes and double quotes both work fine with date(). It's the missing semicolon that matters.
Thank you Bob. I had seen exactly what you thought people might see and missed the point entirely;
I am excited about this thread but can't contribute currently, I hope I can add value here in a week..or so
Anyone reading who has similar issues/questions should go ahead and jump in now while the water is fine!