sails js find duplicate records on same date

 

//Check the duplicate

for (let i = 0; i < findConsultation.length; i++) {

       findConsultation[i]["isDuplicate"] = false;

findConsultation[i]["duplicateCount"] = 0;

//get previous date and current date

let previousDate = new Date(moment(1706182022835).subtract(1, 'days').format('MM-DD-YYYY')).getTime();

let nextDate = new Date(moment(1706182022835).add(1, 'days').format('MM-DD-YYYY')).getTime();

let duplicateCount = await Consultation.count({ memberId: findConsultation[i].memberId.id, createdAt: { "<": nextDate, ">": previousDate } });

// if duplicate data

if (duplicateCount > 1) {

findConsultation[i]["isDuplicate"] = true;

findConsultation[i]["duplicateCount"] = duplicateCount;

}

}