Index: backend/scripts/sendEmailToModerator.js
===================================================================
--- backend/scripts/sendEmailToModerator.js	(revision fae62778184fe587f3cb4d196752e6171a9525a6)
+++ backend/scripts/sendEmailToModerator.js	(revision 8ecb8a99ba5549108adc98c6e5419ed5381249b8)
@@ -1,8 +1,8 @@
-require('dotenv').config({
-  path: require('path').resolve(__dirname, '../.env'),
+require("dotenv").config({
+  path: require("path").resolve(__dirname, "../.env"),
 });
-const { sendModeratorEmail } = require('../services/emailService');
-const schedule = require('node-schedule');
-const prisma = require('../lib/prisma');
+const { sendModeratorEmail } = require("../services/emailService");
+const schedule = require("node-schedule");
+const prisma = require("../lib/prisma");
 
 async function sendmailToModerators() {
@@ -14,10 +14,10 @@
   try {
     const oneDayAgo = new Date();
-    oneDayAgo.setDate(oneDayAgo.getDate());
+    oneDayAgo.setDate(oneDayAgo.getDate() - 1);
 
     const posts = await prisma.to_be_reviewed.findMany({
       where: {
         created_at: {
-          lt: oneDayAgo,
+          lte: oneDayAgo,
         },
       },
@@ -27,5 +27,5 @@
       },
       orderBy: {
-        created_at: 'asc',
+        created_at: "asc",
       },
     });
@@ -38,5 +38,5 @@
 
     if (posts.length === 0) {
-      console.log('No old posts to review. No emails sent.');
+      console.log("No old posts to review. No emails sent.");
       return;
     }
@@ -96,5 +96,5 @@
 }
 
-const job = schedule.scheduleJob('0 7 * * *', function () {
+const job = schedule.scheduleJob("0 7 * * *", function () {
   console.log(
     `[${new Date().toISOString()}] Running scheduled moderator email check`
@@ -107,5 +107,5 @@
 );
 
-process.on('SIGINT', function () {
+process.on("SIGINT", function () {
   job.cancel();
   console.log(
