SQL Server Date/Time fields

Discussion created by deano2020 on Aug 9, 2012
I'm wondering if anyone knows how to query date/time fields of a SQL Server 2008 database using an ODBC connection in MS Access?  I have attached a screenshot of how the SQL date/time field looks inside Access.  I'm pretty new to SQL and the Access function DateValue() doesn't seem to work with these SQL date/times.  I'm wondering if there is another function that works in order to group date/times by date?

Thanks in advance!