how do i get the count of cases passed/failed/etc for a specific day or just today ?
Have you taken a look at the activity reports in TestRail, e.g. linked from the project pages or runs/plans/milestones (see the links in the sidebar)? This shows the activity and results per day.
I hope this helps!