I seem to be having problems with querying the database using the DATETIME fields. I have tried defining the whereClause of the query a number of ways but I always get all of the objects back whether their created date is before or after the specified date. Some of the formats that I have tried:
created >= 2014-01-10T16:54:00.000
created >= 2014-01-10 16:54:00 +0000
created >= 2014-01-10 16:54:00 GMT+0200
Changing the sign to “<=” stops any objects from coming back. Adding ‘’ around the date or # returns an “invalid where clause” error 1017.