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!