View Single Post
Old 04-09-2015, 03:22 PM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058

What is the data type of the underlying column? If it is a datetime then you shouldn't need to wrap the parameter in single quotes.

Just ... WHERE fldAuditDate = @varAuditDate
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote