Open andrewatjanover opened 2 years ago
INPUT Json:
[ { "RUNDATE": "12/13/2021" }, { "RUNDATE": "12/13/2021" } ]
EXPECTED OUTPUT [ { "rundate" : ISODATE("12/13/2021") } ]
Not too many useful articles on how to insert the date as an ISODATE. Thanks for your help in advance. Essentially the ISODATE throws an exception because it's not valid JSON, but then how does one get an ISODATE valid field in their json?
INPUT Json:
[ { "RUNDATE": "12/13/2021" }, { "RUNDATE": "12/13/2021" } ]
EXPECTED OUTPUT [ { "rundate" : ISODATE("12/13/2021") } ]
Not too many useful articles on how to insert the date as an ISODATE. Thanks for your help in advance. Essentially the ISODATE throws an exception because it's not valid JSON, but then how does one get an ISODATE valid field in their json?