Skip to main content
Question

API Export of Dates

  • July 5, 2019
  • 0 replies
  • 57 views
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. 

    This topic has been closed for replies.

    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.
    • ChrisFaye1
    • Author
    • Quickbase Alumni
    • July 15, 2019
    Thank you, Charlie!
    Forum|alt.badge.img+15
    • DonLarson
    • Quickbase Alumni
    • November 14, 2019
    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
    ------------------------------
    Terms & ConditionsAccessibility statement