mongodb remove all dates less than specified

Question

I have the following data.

{
    deviceID: 186,
    date: "2014-3-15"
}
{
    deviceID: 186,
    date: "2014-3-14"
}
{
    deviceID: 186,
    date: "2014-3-13"
}

And some lower dates, like 2014-3-9 , 8 ,7 ,6 etc.

When doing a db.coll.remove({date:{$lte:"2014-3-5"}})

Mongo removes the 15,14,13 aswell, but keeps single digit day dates. Is this maybe due to the date is a string?

I dont know how else to format the date so I can remove all dates below a certain date.

It is supposed to be a cleaning process, removing all documents with a date lower than specified.

Answer 1

Its because the date field you are querying on is a string filed and not a Date(). In your mongo documents instead of a custom date string, insert javascript date objects into date field.

like

{ deviceID: 186,,"date": new Date(2012, 7, 14) }

and when you execute the remove do it like

db.coll.remove({date:{$lte:new Date(2012, 7, 14)}})