1

Is it possible to do a date based query with mongo if a field is a millisecond timestamp rather than an ISODate?

For example, I get no results for this query when startDate is a timestamp:
{
“collection”: “Program”,
“aggregate”: [
{
“$match”: {
“startDate”: {
“$gt”: {
“$humanTime”: “30 days ago”
}
}
}
}
}

2

does “date” and epoch time in millisecond work?

{
  "collection": "Program",`
  "aggregate": [
    {
      "$match": {
      "startDate": {
        "$gt": {
          "$date": 1504414800000
        }
      }
    }
  }
}
3

you can use “$addFields” to add date transfer the timesamtp to isotime and then do “$match”