using Date query with $gte and $lte operators.

[shubhanshusingh]

var fdb = new ForerunnerDB();
var cdb = fdb.db("compute");
var fdbcollection = cdb.collection("vipData").deferredCalls(false);

vipPass = vipPass.map(function (vp) {
 console.log(vp.vip_end
 instanceof
 Date)

 return {
 u_id: vp.u_id,
 vip_end: fdb.make(vp.vip_end),
 vip_start: fdb.make(vp.vip_start)
}
})
// insert data into forerunner db
fdbcollection.insert(vipPass)

console.log("DATA inserted into forerunner.")
// query data based on operator based date.
let results = fdbcollection.find({
u_id: singleTxnObj.u_id,
// vip_end: {$lte: singleTxnObj.createdAt.toString()},
// vip_start: {$gte: singleTxnObj.createdAt.toString()}
}, {
$limit: 1
});

console.log(singleTxnObj.createdAt instanceof Date) //true
console.log(luxon.DateTime.fromISO(singleTxnObj.createdAt.toString()).toJSDate() instanceof Date) // true

console.log(results[0].vip_end instanceof Date) // true
console.log(results[0].vip_start instanceof Date) // true

as per the code above I have inserted Date fields with other fields and also in case of results from query I can see that the fields are instance of Date.

I have used fdb.make, but the result based on $gte & $lte doesn't work, as it doesn't return any data results.

Wanted to know if $gte & $lte can be applied to queries like these?

[Irrelon]

It should work fine. Try using the actual date instance rather than toString() in the query.

[Irrelon]

Hey I notice this is closed, did that solve the problem?

[shubhanshusingh]

toString() was one of the problem, the query with those fields. $lte should be $gte and vice-versa, my bad.