Domo changes date on its own with Excel connection

I'm having a bit of trouble with using the Excel connector to pull in data from a spreadsheet.

The first column I have in the spreadsheet contains a date. Each row represenst the start of a week. For the spreadsheet in question, the first date listed in the sheet is 5/23/2016. The next would be May 30, 2016, and so on. When I use the Excel connector, however, Domo will move each of the dates back by one day. So the first date listed within the Domo dataset is May 22, 2016.Β 

Why is Domo doing this? And most importantly, how can I prevent it?

Comments

  • AS
    AS πŸ”΅

    Does your Excel column secretly have a timestamp in the data? Β That can sometimes have unexpected consequences.