Hi, i would like to know how can we aggregate dates based on user’s timezone. For example, I have made a system which gets the entry log and exit log in a day. When you are saving dates in MongoDB, it converts it to UTC 0. If user’s timezone is in UTC +8, then all dates saved will have -8 hours. If a worker enters at 4AM in sept 22,2024, the date stored in the database will be at sept 21, 2024 at 8pm. So if the user wants to see the entry log at sept 22,2024 and we used:
$match: {
entryTime: {
$gte: new Date(“2024-09-22T00:00:00”),
$lte: new Date(“2024-09-22T23:59:59”),
},
}
Nothing will appear since in the database, the worker entered at sept 21, 2024 at 8pm. How will be my approach here? Should i just add +8 hours to the date before saving it so it would be at UTC +8?