topic SQL Server Date/Time fields in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/sql-server-date-time-fields/m-p/640004#M24560 <HTML><HEAD></HEAD><BODY><SPAN>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?&nbsp; I have attached a screenshot of how the SQL date/time field looks inside Access.&nbsp; I'm pretty new to SQL and the Access function DateValue() doesn't seem to work with these SQL date/times.&nbsp; I'm wondering if there is another function that works in order to group date/times by date?</SPAN><BR /><BR /><SPAN>Thanks in advance!</SPAN></BODY></HTML> Thu, 09 Aug 2012 13:25:47 GMT MatthewBoyle 2012-08-09T13:25:47Z SQL Server Date/Time fields https://community.esri.com/t5/arcgis-enterprise-questions/sql-server-date-time-fields/m-p/640004#M24560 <HTML><HEAD></HEAD><BODY><SPAN>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?&nbsp; I have attached a screenshot of how the SQL date/time field looks inside Access.&nbsp; I'm pretty new to SQL and the Access function DateValue() doesn't seem to work with these SQL date/times.&nbsp; I'm wondering if there is another function that works in order to group date/times by date?</SPAN><BR /><BR /><SPAN>Thanks in advance!</SPAN></BODY></HTML> Thu, 09 Aug 2012 13:25:47 GMT https://community.esri.com/t5/arcgis-enterprise-questions/sql-server-date-time-fields/m-p/640004#M24560 MatthewBoyle 2012-08-09T13:25:47Z