I linked a few lists from a SharePoint site to Access 2013 and discovered that Access sets the Data Type for that filed to Number. While Access displays in correct value in View mode, it's treating the data as numbers underneath the covers.
I really want to use those date values. What's the best approach to fix this? Should I modify something on the SharePoint side? (not desirable) -- or adjust something on the Access side? (more desirable)
The data data in SharePoint is formatted as:
d/m/yyyy
Any help is most appreciated.