---
title: "DataShed4 - Date Fields Display incorrectly"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/1085505573/DataShed4%20-%20Date%20Fields%20Display%20incorrectly"
format: markdown
---
**Issue:**

Date display as YYYY-MM-DD in some tables and DD/MM/YYYY in others

![image](media://1baf0488-b0dc-4aaf-bad7-0e32b561d145)

![image](media://146a9387-3cfa-4287-aa55-c010c7682a46)

**Cause:**

ODBC Driver incompatibility with with SQL Server version hosting the database

**Resolution:**

Update the DataShed4 ODBC to use a compatible ODBC Driver based on the below chart  

![image](media://49904027-7e94-4f00-9d79-6172e6dccc2a)

ODBC Driver 17 and 18 can be downloaded from the below link.

[https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16](https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16) 

ODBC Driver System requirements and SQL Server Compatibility. 

[https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?source=recommendations&view=sql-server-ver16](https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?source=recommendations&view=sql-server-ver16)