Dates show a day ahead

user07319
user07319 Member
in Charting

I am creating a card and noticed that the data in my Date field is being changed, For example 2019-04-17 18:16:00 shows as 18 Apri 2019 18:16:00 AM. I am not sure why DOMO is adding a day to the raw value. 

Comments

  • Godiepi
    Godiepi Coach

    It all comes to your company time zone settings and the time zone you are telling Domo your data is in when importing it throught workbench.  take a look at this article from the Domo knowledge base

     

    https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ

     

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • ST_Superman
    ST_Superman Domo Employee

    Double check the values you are seeing too.  I'm guessing that it is just pushing to forward 10 hours.  That would change 2019-04-17 18:16:00 to be 18 Apri 2019 08:16:00 AM... not 18:16 AM.

     

    Either way, if this is a workbench job then I think the fix is to add a "Shift Data Timezone Transform" to your workbench settings:1.png

     

    You will just need to know what time zone your source data is using

  • user07319
    user07319 Member

    I am currently using workstation to import from a MSSQL database. The Transforms -> Shift Date Timezone has been set to UTC-07:00. This was setup a while ago. The dates are entered in the data base via UTC date. We need to view the dates in Mountain Time.

  • ST_Superman
    ST_Superman Domo Employee

    If the dates are entered via UTC, then you don't want to use any timezone shift.  The data needs to come into Domo in UTC.  The timezone shift is in the event that the source system does not use UTC.

     

    The company settings will then let you specify that you want to view Mountain Time

  • user07319
    user07319 Member

    OK, got it. I removed it and now the dates are working like it should. Thanks for the help

  • user07319
    user07319 Member

    I have noticed that after 5 PM PST, all my cards are blank. I need to show all data for the current day. I am not sure why the cards are blank after this time of day

  • user07319
    user07319 Member

    Found that my dates are not UTC but  (GMT+0) format. What is the best way to convert to UTC?

This discussion has been closed.

Categories