I am working with a VIEW inside of SQL Server. I want to SELECT DISTINCT just the date from a date/time field. (MM/DD/YYYY). And then I want to be able to use BETWEEN to requery the resulting data from that view. So to get rid of the time, I am using the Convert function: SELECT DISTINCT Order_id, CONVERT(char(10), Customer_Order_table.date_order_placed, 101) AS order_date >From MyTable The trouble is that when I go to requery the data from a second query, my between statement doesn't seem to work properly and I don't get any records returned. It's almost like the resulting data isn't being considered a date or something like that. Does anyone have any suggestions on this? Thanks, Eron __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
