Finding Documents created today

Question

So, In meteor, I am trying to count the number of documents created today. Obviouly the code below tries to match it to the time of the day along with the date.

var ct2 =  Bids.find({$and:[{bidder:currentUser},{createdAt:Date()}]}).count();

How do I go about finding the number of documents for today ?

Thanks in advance.

score 3 · Accepted Answer · edited May 23 '17 at 12:15

3

You might need to do something like this

Query to get last X minutes data with Mongodb

var ct2 =  Bids.find({
    $and: [
       { bidder: currentUser },
       {
           createdAt: { $gt: new Date(Date.now() - (1000 * 60 * 60 * 24)) }
       }
    ]
}).count();

edited May 23 '17 at 12:15

Community

1
1

answered Feb 04 '16 at 03:26

Kishor

2,659
4
16
34

ISODate not defined. – user1487244 Feb 04 '16 at 03:40
Can you try with `Date.now()` instead of `ISODate().getTime()` and see. Basically you need to get current time in milliseconds and remove last 24 hours from it. – Kishor Feb 04 '16 at 03:45
Nice to know that it worked. Can you accept it as answer. – Kishor Feb 04 '16 at 04:07

score 1 · Answer 2 · answered Feb 05 '16 at 13:00

1

By using moment js:

date=moment().add(-1,'days').toISOString();
val1 = checkdate1.substring(0, 11)
temp=val1+'23:59:59.'
val3=date.substring(20,25)
val4=temp+val3;
count = Bids.find({"createdAt": {$gt:new Date(val4)}}).count()

answered Feb 05 '16 at 13:00

sravanthi

247
1
6

Finding Documents created today

2 Answers2