Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

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?
Tagged:

Answers

Sign In or Register to comment.