Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
6 years ago

API Export of Dates

I'm connecting a BI tool called Grow to Quick Base and see that all non-time stamp date field are coming over in UNIX-13. The funky thing is when I convert this all fields convert properly except one field shows the converted result as some records being 1 hour behind the accurate result. Any ideas why this is?

*This is only a date entry field, not a formula field. 

In this case: 19:00:00 is the correct time. Once I get this figured out then I do a time-shift of +5 hours to get it back to midnight. 

  • You need to take DST (daylight savings time into account) and having experienced this in PowerBI its a PITA. Your dates that are off by 1 hour occurred before DST which was march 10 this year I believe.

    I'm not familiar with grow but if there's some scripting capability similar to pq/dax (powerBI) you'd have to 1: get the app's timezone (via getschema I believe) and 2. for each date apply a +6 for all times prior to DST and +5 for all after.
    • CharlieMurawski's avatar
      CharlieMurawski
      Qrew Cadet


      API_getSchema confirmed. So that's how you can get your offset for each app however you need to consider 1. does this timezone even do DST, and 2. what are the time bounds of it (I don't believe it happens on the same day in each time zone, at least globally)
  • Chris,

    We have built a tool called Paasporter that extracts Quick Base data and will build a SQL compliant DB.   Connection to BI is the first reason we did it.  I have a couple clients on Tableau and their developers needed to be able to use the standard data source connection and write SQL queries against the QB Data and other sources.

    I would be happy to show it to you. Once you have SQL the other side can be virtually any standard development tool.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------