// 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)