JSFiddle - React, Tailwind, and code Playground
by Rishabh Sharma
JavaScript
var startingCLO = new ISODate('2019-02-05T00:00:00.000Z');
Date.prototype.addDays = function(num) {
var value = this.valueOf();
value += 86400000 * num;
return new Date(value);
}
db.getCollection("order").find({}, {
orderId: 1,
expiryDate: 1,
_id: 0
}).toArray().map(function(obj) {
var newCLODate = new Date(startingCLO);
for (var i = 0; i < 27; i++) {
var add = 14 * i
if (i == 0) {
add = 0
}
newCLODate = newCLODate.addDays(add)
if (newCLODate - obj.expiryDate === 0) {
return obj;
}
}
}).filter(function(obj) {
if (obj !== undefined) {
return obj
}
})