Visit the official Paxata Documentation portal for all of your doc needs.

DATE in JSON Extract Does Not Import as DATE column type

When we export a dataset from Paxata into JSON, the date is formatted as:

"TIMESTAMP" : "2019-03-25T04:38:46.449Z",

If we use that JSON as a data source, Paxata does not automatically recognize the format as a date value so it imports it as a text value. As a workaround, we are using a computed column with the DATEVALUE formula but it doesn't accept that string format. We're using the following:

DATEVALUE(@[email protected] ,"YYYY-MM-dd'T'hh:mm:ss.ZZZ'Z'")

Is there a way to address this either on the export or in the formula after import?

Best Answer


Sign In or Register to comment.