mongodb comparing date entry with current date

Question

I want to aggregate entries whose date is less than 1 week old from today.

{ "collection": "my-lovely-collection", "aggregate": [ {"$match": {"some_field": { "$regex": "awesome*"}}}, {"$match": {"created": {"$lt": {"$dateToString": {"date": {"$dateSubtract": {"startDate": {"$currentDate": {"$type": "date"}}, "unit": "day", "amount": 7 }}}}}}}, {"$group": {"_id": "$some_field", "count": {"$sum": 1 }}}, {"$sort": [{"name": "count", "direction": 1}]} ] }

When I use a hard-coded date for today everything works fine (but that's not what I want)

{"$match": {"created": {"$lt": "2022-08-29"}}}

Does this answer your question? MongoDB find Query comparision with CurrentDate — Dezzley
– Dezzley, Commented Aug 29, 2022 at 16:24
@DimiVi I can't seem to subtract 7 days from today and compare to that - even after using new Date() - any ideas? thanks ! — OrenIshShalom
– OrenIshShalom, Commented Aug 29, 2022 at 16:32

Dezzley · Accepted Answer · 2022-08-29 17:08:04Z

1

You could use $dateSubtract:

 { $match: { $expr: { $lt: [ "$created", { $dateToString: { format: "%Y-%m-%d", date: { $dateSubtract: { startDate: "$$NOW", unit: "week", amount: 1 } } } } ] } } }

Mongo Playground: https://mongoplayground.net/p/QWT4ar4gbt0

Documentation: https://www.mongodb.com/docs/manual/reference/operator/aggregation/dateSubtract/

edited Aug 29, 2022 at 17:08

answered Aug 29, 2022 at 16:22

Dezzley

1,9151 gold badge20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

OrenIshShalom Over a year ago

I can't seem to subtract 7 days from today and compare to that

Dezzley Over a year ago

Gotcha. Updated my answer

OrenIshShalom Over a year ago

Arrrggghh ... still not working - You don't use the "$dateToString" - is it not needed? (you also have a typo with an extra $ in "$created"

Dezzley Over a year ago

@OrenIshShalom so I assume your created field is a string. If yes so I updated my answer in accordance, please take a peek. If no, please provide your collection schema for better visibility :)

OrenIshShalom Over a year ago

thanks for the mongo playground link !

Collectives™ on Stack Overflow

mongodb comparing date entry with current date

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related