I am using the Microsoft Sharepoint Online Connector to bring in some data from an excel file. I have a date column, that for whatever reason, comes into the DOMO datebase a day earlier than what is listed in the excel document. It has also added time to the date column. I have tried lots of different date formats to see if it changes anything, but it is always different.
Comparing the data it looks like this:
Excel file:
Wednesday, December 2, 2020
Domo database:
1 Dec 2020 17:00:00 PM
Anyone have any ideas why it is doing this? I thought that perhaps it is accounting for timezones or differences? but that doesn't make sense to me.
Thanks for your help!