db.livepolicies.aggregate() .match({ masterGroupID1Count: { $exists: true } }) .project({ 'DateString': { $dateToString: { format:'%Y-%m-%d', timezone: "Europe/London", date: '$etlDate' } }, 'Boiler': '$masterGroupID1Count', 'Appliance': '$masterGroupID2Count', 'Home Emergency': '$masterGroupID3Count', 'Car': '$masterGroupID4Count', }) .sort({ etlDate: -1 })