Mongo DB Tool Criteria is not working for date filter

Hi Team,

I am stuck with a problem while using Mongo Db Input tool.

I want to extract the data from a particular date range but when i typed a query in criteria , it returns error. I have tried all the way but date filter is not working in it.

query is:

{ "createdDate": { $gt: ISODate("2016-05-27T14:47:23.148+0000") } }

Thanks in advance.

Regards

Nipun Garg

MongoDB

Accepted answers

MikeSp

Hi @Nipun,

I happened to be looking through the community and noticed your post here after helping out with a case that you submitted. I wanted to post the resolution here in case someone else has the same issue.

The MongoDB drivers as of the 2018.x series have been upgraded to support MongoDB 3.4+, and these new drivers do not support shell mode commands when it comes to MongoDB. You'll need to update your criteria to use the Strict format in order for this to function correctly. Documentation on this can be found on MongoDB's website here: