Thanks guys, for the quick responses...
I actually had the # symbol arround the date correctly in the code, but I messed up as I was re-writing it here...Again, I am kinda a beginner here so let me verify what you are both saying...
I'm not exactly sure where "docmd.transfertext" should be...