Hi, I have a table with a date/time field in an Access database. I want to have a query grouped on the date, with no regard to time, so that all records from the same day are grouped. I need a function (in SQL) that will extract the day part of a date/time value, in a form that is still suitable for sorting, and I connot find any one.
I tried LEFT(mydate, 8), but it generates a date like mm/dd/yy not suitable for sorting. What I need is the date of the day in true date format, not as a string. Any idea ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
