cancel
Showing results for 
Search instead for 
Did you mean: 

Why do my date fields in Paxata change when I connect to vizualization tool?

Highlighted
Blue LED
My answersets in Paxata contain date fields in the standard Paxata format (2019-06-30T00:00:00.000Z) but when I connect to the answerset in another tool (Power BI), that same date field appears as "6/29/2019 8:00:00 PM". Similarly, 2019-012-11T00:00:00.000Z becomes "12/11/2019 7:00:00 PM". All my dates seem to have a 5hr discrepancy during Standard Time or a 4hr discrepancy during Daylight Savings Time (I am in ET). Why is this happening, and short of changing the format of each date field individually, how can I keep this from happening?
Labels (1)
0 Kudos
1 Reply
Highlighted
Linear Actuator
Paxata attempts to internally manage dates in GMT/UTC. When you export your data from Paxata into another system, that system may interpret those timestamps in the timezone configured for that system/server. This appears to be what happens with Power BI. 

Perhaps this question will help you reformat the timestamps back into UTC
https://community.powerbi.com/t5/Desktop/change-a-data-time-column-in-GMT-format-to-data-time-timezo...

Thanks,
Bill
0 Kudos