mongodb - date comparison doesn't work in aggregation

Question

I have the following aggregation:

db.runCommand(
  {"aggregate":"Order","pipeline":[
    {"$match":{"shopId":28440395907}},
    {"$match":{"createdAt":{"$gte":{"$date":{"$numberLong":"0"}}}}},
    {"$sort":{"updatedAt":-1}},
    {"$facet":{"results":[{"$skip":0},{"$limit":25}],"count":[{"$count":"count"}]}}
  ],"allowDiskUse":true,"cursor":{}}
);

The problem is that it fails to return any results. Replacing the date filter with literally anything else provides results so my guess is that there is a problem with date conversion. I tried all the versions I found in tutorials (like new Date("2015-06-17 10:03:46.000Z")), it always acts the same. Can anyone please explain why and how to fix?

Answer 1

The date format is wrong, use the format according to ISO-8601:

new Date("2015-06-17T10:03:46Z")

or

ISODate("2015-06-17T10:03:46Z")

ISODate() is an alias for new Date() you have in the mongo shell.

Format 2015-06-17 10:03:46Z is commonly used but not compliant to ISO-8601 standard if you like to specify a time at a certain day.