Slightly confused, exactly what are you looking for here, a count of records for today, yesterday, and the past 7 days excluding today?