Data to JSON , Date conversion?

sgham

I want to read data from a MongoDB collection using RapidMiner Studio and will be giving a criteria (a json format) to the Read Mongo DB operator. To do this, I need a datapoint stored in a dataset and converted it to table format using Data to JSON operator. Given that I have a field called 'Date' in ISO date format, when I convert Data to JSON using the above operator that date format changes to some other format like milliseconds I guess. However I need it to perform my search in the MongoDB in its original format. What to do?

jwpfau

Hi,

you could i.e. add a Date to Nominal operator with a yyyy-MM-dd'T'HH:mm:ss'Z' format before the Data to JSON operator to create the ISO 8601 date format.

Greetings,
Jonas