Mongo input criteria error

[VJ_dup_337]

Guys,

I want to filter the Mongo DB data using insTimeStamp column. below is the sample data.

{
"_id" : ObjectId("5937a5dea2ced9634b7dc390"),
"memberId" : NumberInt(9463),
"transId" : "18733958xx",
"actualCredits" : NumberInt(5),
"currentCredits" : NumberInt(5),
"stamps" : {
"insTimeStamp" : ISODate("2017-06-07T12:36:06.000+0000"),
"updTimeStamp" : ISODate("2017-06-07T12:36:06.000+0000")
},
"expiry" : ISODate("2017-06-10T18:29:59.999+0000")
}

I have used below criteria for the same but getting an error. please guide me on this.

Error: MongoDB Input (3): code FailedToParse: FailedToParse: Bad characters in value: offset:24 of:{ "stamps.insTimeStamp": ISODate("2017-06-07T12:36:06.000+0000") }

[VJ_dup_337 · Accepted solution]

Hi @MikeSp 

The solution which you provide is worked for me :)

{"stamps.insTimeStamp":{$lte:{$date: "2017-06-16T00:00:00.000+0000"}}}

Thanks for the guidance :)

Need your expertise on one more query, We want to schedule a workflow to pull the data from Mongo DB for last three days without any manual intervention is there any way to do this?