Forum Discussion

YvonneP's avatar
YvonneP
Copper Contributor
Jan 20, 2021

SharePoint list exported to Excel has different dates

One of our users has this problem:
The dates appear correctly for her in the SharePoint list, but once she exports the list to excel as a query.iqy, the dates change.

Here an example:
(SharePoint list view)
Entry A: 25.03.2021
Entry B: 20.01.2021

 

(Exported in excel view)
Entry A: 26.03.2025
Entry B: 21.01.2025

1 Reply

  • Sihuss's avatar
    Sihuss
    Copper Contributor

    YvonneP I note that you got no replies to this - Did you ever figure out what the issue was?

     

    My field is Date and Time and it's automatically extracted from email metadata (.eml format files), so it's not an issue with data-entry.  Looks fine on SharePoint but either blank or just plain wrong in the exported Excel listing

Resources