Yes - you have to provide a STRING literal that represents the date to SQL Server, which it then converts to DATE or DATETIME. String literals are those things that are enclosed in single quotes.
Thank you!
Im making progress!! It is still not running but getting further in the process.....
It ran and gave me the correct results.......I have the variables in my group by clause again. I recall several months ago having a problem with variables in a group by, I took them out and it worked!
Thanks again for all the help, James!
To know more on why you need to use unambiguous date format, read this post http://beyondrelational.com/modules/2/blogs/70/posts/10898/understanding-datetime-column-part-ii.aspx