// mongosh
function getLastFridayNYMidnightUTC() {
const now = new Date();
const daysSinceFriday = (now.getDay() - 5 + 7) % 7; // Friday = 5
return new Date(now.getFullYear(), now.getMonth(), now.getDate() - daysSinceFriday, 0, 0, 0, 0);
}
const lastFriday = getLastFridayNYMidnightUTC();
print("Last Friday (NY midnight) =", lastFriday.toISOString());
// Find all docs where dateTime > lastFriday
db.getCollection("app").find(
{
$expr: {
$gte: [
{ $dateFromString: { dateString: "$timestamp.dateTime" } },
lastFriday
]
}
},
{ _id: 1, "dateTime": 1 }
).forEach(printjson);
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)