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 ...
Forum Discussion
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.
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.
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)