JAVASCRIPT

get number of days between two dates mongodb query

db.collection.aggregate([
  {
    $project: {
      days: {
        $dateDiff: {
          startDate: "$start",
          endDate: "$end",
          unit: "day"
        }
      },
      _id: 0
    }
  }
])

get days months and years between dates mongodb

db.collection.aggregate([
  {
    $project: {
      Start: "$start",
      End: "$end",
      years: {
        $dateDiff: {
          startDate: "$start",
          endDate: "$end",
          unit: "year"
        }
      },
      months: {
        $dateDiff: {
          startDate: "$start",
          endDate: "$end",
          unit: "month"
        }
      },
      days: {
        $dateDiff: {
          startDate: "$start",
          endDate: "$end",
          unit: "day"
        }
      },
      _id: 0
    }
  }
])