I am trying to see last three months data, but my code gives me all data. It doesnt give last three months data.
You can see the result in both cases i am getting data from 2023. Ex: “2023-12-12T00:36:52.606Z”
Backend:
controler.js This doesn’t work.
let sixMonths = new Date();
const invoices = await Invoice.find({
createdAt: { $gte: sixMonths.setMonth(sixMonths.getMonth() - 6) },
});
Gives:All data
Result:
[
"2024-08-04T23:31:21.226Z",
"2024-08-05T00:42:49.717Z",
"2022-08-05T01:11:20.363Z",
"2024-07-05T01:11:58.174Z",
"2024-01-05T01:11:59.248Z",
"2024-08-05T01:12:00.338Z",
"2024-08-05T01:54:10.774Z",
"2024-08-05T01:54:35.970Z",
"2024-02-05T02:48:05.768Z",
"2024-06-12T00:36:25.598Z",
"2024-07-12T00:36:25.815Z",
"2024-07-12T00:36:26.364Z",
"2024-08-12T00:36:51.954Z",
"2024-08-12T00:36:52.109Z",
"2024-07-12T00:36:52.264Z",
"2024-01-12T00:36:52.433Z",
"2023-12-12T00:36:52.606Z",
"2024-04-12T00:36:52.780Z",
"2024-05-12T00:36:53.005Z",
"2024-08-12T00:38:26.562Z",
"2024-07-31T00:38:27.675Z",
"2024-08-12T23:20:11.702Z"
]
**
Backend:
controler.js ** This doesn’t work.
var threeMonthsAgo = new Date();
threeMonthsAgo.setMonth(threeMonthsAgo.getMonth() - 3);
var threeMonthsAgoInSeconds = threeMonthsAgo.getTime() / 1000;
const invoices = await Invoice.find({
createdAt: { $gte: threeMonthsAgoInSeconds },
});
Gives:All data
Result:
[
"2024-07-05T01:11:58.174Z",
"2024-01-05T01:11:59.248Z",
"2024-02-05T02:48:05.768Z",
"2024-08-11T15:34:43.434Z",
"2024-06-12T00:36:25.598Z",
"2024-07-12T00:36:25.815Z",
"2024-08-12T00:36:26.018Z",
"2024-08-12T00:36:26.204Z",
"2024-07-12T00:36:26.364Z",
"2024-08-12T00:36:51.954Z",
"2024-08-12T00:36:52.109Z",
"2024-07-12T00:36:52.264Z",
"2024-01-12T00:36:52.433Z",
"2023-12-12T00:36:52.606Z",
"2024-04-12T00:36:52.780Z",
"2024-07-16T01:11:18.913Z",
]
Invoice.model.js
import mongoose from "mongoose";
const { ObjectId } = mongoose.Schema;
const invoiceSchema = mongoose.Schema(
{
customerName: {
type: String,
},
},
{ timestamps: true }
);
const Invoice = mongoose.model("invoice", invoiceSchema);
export default Invoice;
This is how data is saved in mongodb:
{
"_id": {
"$oid": "66b96341d443780c300af038"
},
"customerName": "Mehdi",
"createdAt": {
"$date": "2024-08-12T01:20:01.383Z"
},
"updatedAt": {
"$date": "2024-08-12T01:20:01.383Z"
},
"__v": 0
}
If i want last 3 months like this 2023’s(November,December) + 2024’s (January)
how do i do that????
I am trying to get MongoDB last 3 months data, but failed in every thing and every way. Need help on that.
Mehdi Hasan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Your query works when you are trying to fetch the documents created within the latest 3 months.
However, if you want to query the document from a specific range (For example: from November 2023 to January 2024), you must apply the filter with the start date ($gte) and end date ($lt).
const invoices = await Invoice.find({
createdAt: {
$gte: ISODate("2023-11-01"),
$lt: ISODate("2024-02-01")
}
})
Demo @ Mongo Playground
I am not sure how you define the start date, assume that it is from the user input or your specified value.
var startDate = new Date("2023-11-01T00:00:00.000Z");
var endDate = new Date(startDate.setMonth(startDate.getMonth() + 3));
const invoices = await Invoice.find({
createdAt: {
$gte: startDate,
$lt: endDate
}
})