I need to check if a date is in between two dates in mongodb.
queryDates={ startDate: 2023-11-19T05:31:18.997Z, endDate:
2023-11-25T05:31:18.997Z }
Document data
fromDate: 2023-11-22T00:00:00.000+00:00, toDate:
2023-11-24T00:00:00.000+00:00
mongoDb query
{
$and: [
{ fromDate: { $gte: queryDates.startDate } },
{ toDate: { $lte: queryDates.endDate } },
],
}
For this case i am getting correct document. But if queryDates.startDate
and queryDates.endDate
is in between fromDate
and endDate
, how to write query for that?