Hi Mike,
You can not edit existent column type.
But it's easy to delete current column and create new column with type you need.
Yes you can use "createdAt" field as well as "updatedAt" field.
But here is some difference.
Base query string is:
pre
{"_createdAt": {$gt: {"$date": "2011-04-15T00:32:22.883Z"} } }
/pre
So code should be:
pre
var d1 = new Date(Apperyio("startDate").datapickerRoot.find("input").val()).toISOString().replace(/T.*/gi, "") + "T00:00:00.000Z";
var d2 = new Date(Apperyio("endDate").datapickerRoot.find("input").val()).toISOString().replace(/T.*/gi, "") + "T00:00:00.000Z";
var whereObject = {
$and: [{
"createdAt": {
$gt: {
"$date": d1
}
}
}, {
"createdAt": {
$lt: {
"$date": d2
}
}
}]
};
return JSON.stringify(whereObject);
/pre
Regards.