_createdAt date - query just doesn't work

[Ilya]

Hi!

I wanted to make query to the default column '_createdAt', but this doesn't work - DB returns just blank info. If i create field 'Date' with date type and then populate it with absolutely similar information, then do the query - it works ok.

So the question is - why i can't query '_createdAt' field?

[Igor]

Hi,

Please show us your query parameters.

[Ilya]

doesn't work:
{"_createdAt" : "2014-01-03 12:51:49.725"}

works:
{"taskDate" : "2014-01-03 12:51:49.725"}

of course in both rows - same values - for testing purposes.

[Igor]

This should work:

pre
{"_createdAt":{"$gte":{"$date":"2013-05-11T15:10:39.376Z"},"$lte":{"$date":"2013-08-13T17:55:54.129Z"}}}
/pre

[Ilya]

Igor, sorry, but this doesn't work:

{"_createdAt":{"$gte":{"$date":"2014-01-03 11:49:46.172"},"$lte":{"$date":"2014-01-05 20:01:56.484"}}}

For this there are for sure DB entries:

For 2014-01-03 11:49:46.172;

Code: Select all

 { 
     "_createdAt":"2014-01-03 11:49:46.172", 
     "_id":"52c6a3dae4b06de3a9a293c3", 
     "_updatedAt":"2014-01-04 18:37:12.004", 
     "inviteList":{ 
         "invite":[ 
             "John", 
             "Lisa" 
         ], 
         "location":"Art Center" 
     }, 
     "name":"Мирослав", 
     "subtask":{ 
         "collName":"Dates", 
         "_id":"52c69e20e4b06de3a9a2923a" 
     }, 
     "taskDate":"2014-01-01 00:00:00.000" 
 }, 

For 2014-01-05 20:01:56.484

{
"id":"52c9ba34e4b0d96a2c19cc04",
"name":"Григорий",
"createdAt":"2014-01-05 20:01:56.484",
"_updatedAt":"2014-01-05 20:01:56.484"
},

[Igor]

Let's see if query in this format will help. It works for me.
pre
{"_createdAt":{"$gte":{"$date":"2013-05-11T09:56:13.508Z"},"$lte":{"$date":"2013-05-11T09:56:26.888Z"}}}
/pre

[Ilya]

Igor, in what format dates are stored in 'your' db? in 'my' db they are stored in this format: "2014-01-03 13:46:47.149".

[Maryna Brodina]

Hello! Please try this way pre{"_createdAt":{"$date":"2013-11-14T22:35:05.293Z"}}/pre