Visit the official Paxata Documentation portal for all of your doc needs.
Why do my date fields in Paxata change when I connect to vizualization tool?
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?