每个文档包含3个带日期的字段，是否可以根据这些字段中包含的最接近今天的日期返回文档？

db.collection.find({
  $expr: {
    $eq: [
      {
        $arrayElemAt: [
          [
            "$startDate",
            "$endDate",
            "$lastModified"
          ],
          {
            $indexOfArray: [
              [
                { $abs: { $subtract: ["$$NOW", "$startDate"] } },
                { $abs: { $subtract: ["$$NOW", "$endDate"] } },
                { $abs: { $subtract: ["$$NOW", "$lastModified"] } }
              ],
              { $min: [
                { $abs: { $subtract: ["$$NOW", "$startDate"] } },
                { $abs: { $subtract: ["$$NOW", "$endDate"] } },
                { $abs: { $subtract: ["$$NOW", "$lastModified"] } }
              ]}
            ]
          }
        ]
      },
      "$$NOW"
    ]
  }
})

SELECT *,
       LEAST(
         ABS(DATEDIFF(CURRENT_DATE, startDate)),
         ABS(DATEDIFF(CURRENT_DATE, endDate)),
         ABS(DATEDIFF(CURRENT_DATE, lastModified))
       ) AS closestDateDiff
FROM your_table
ORDER BY closestDateDiff ASC
LIMIT 1;