Hmm, MS SQL must do the cast behind the scenes.
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 11:00 AM To: CF-Talk Subject: RE: SQL question Thanks Ben, and Joe here is what finally worked for me. dateCreated >= '04/03/2007' AND dateCreated < DATEADD(DAY, 1, '04/03/2007') With dateCreated >= '04/03/2007' AND dateCreated < ('04/03/2007' + 1) I get this error: Conversion failed when converting the varchar value '04/03/2007' to data type int. So I probably have to cast as a date in order to get this to work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
