Hi,
I am running in a major issue with date capabilities of Mongo 2.6 that is provided with Meteor 1.2.
To clarify, I store Dates in of documents as ISO Date
new Date('2015-04-01 00:00:00')
```
which becomes
```
ISODate("2015-03-31T13:00:00Z")
```
This is all fine and dandy because now I can use the `$month` aggregation operator.
However the big problem arises when I want to group the records per month.
The April 1st converted to March 31 in the ISODate format. So when I do my group by $month, all April 1st records are counted for March and not for April.
Mongo 3.0 has `dateToString` which might make it possible to convert it back to a GMT(n) timezone so that I can do a count.
To fix it now, I dropped the ISODATE format and just store it as `2015-04-01T00:00:00+1100`.
To count the mounts I have to use
```
{
$group: {
_id: {
month: {
$substr: ["$Start Date",5,2]
},
year: {
$substr: ["$Start Date",0,4]
}
},
'count': {
$sum: 1
}
}
```
which looks silly to me.
Any suggestions?