I inherited a very old project. Currently, there is an MS Access 2019 database. This DB has DSN to a MSSQL Server db. There are cross tab queries in MS Access that pulls data from MSSQL and exports that data into excel. The issue is, that dates are coming back as datetime and not date only. They are date only in MSSQL, but somewhere along the way, they are getting converted to datetime.

I have little experience in MS Access or cross tab queries. Throwing out a hail mary to see if anyone out there knows where to start, or what the fix is. Below is a connection string and query in Excel for reference.