> (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) >= > \'08/01/2007\') AND
Yes, that works but could hinder indexes. Josh is correct about date comparisons. If you want all records with a _date_ of 08/01/2007 a better way to write that query is: --- Notice the less than < 08/02/2007 AND dbo.tblUserTransactionLog.Processed >= convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed < convert(datetime, '08/02/2007', 101) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
