JSON to data converter converts dates

udeshika_sewwan

I am reading data from a MongoDB collection using RapidMiner Studio and converted them to table format using JSON to Data operator. Given that I have a field called 'date' in ISO date format, when I convert JSON to data using the above operator that date format changes to some other format like milliseconds I guess. The problem is all the dates converted to one millisecond value '2147483647'. 

Is there a way that I can give a format of conversion or some workaround for this ? 

YYH

Hi @udeshika_sewwan,

You can use “Numerical to Date” operator as a workaround to transform the millisecond values back to a time stamp. Do you have any example json to share for testing?

Cheers,
YY