Domo changes date on its own with Excel connection

bvaut
bvaut Member
in Archive

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 Coach

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

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories