I have a complex Excel 2013 Spreadsheet that is acting as a linked table in an Access 2013 database to facilitate reporting.
The interesting, but frustrating thing is that the dates in Excel are coming into Access as the day before. For example; a date in Excel that is 12/20/2016 appears in Access 2013 as 12/09/2016.
Any ideas on how I can get the two applications to show the date as the same value? i.e. 12/20/2016 in both Excel and Access