Grouping counts by month isn't working

Hi! Hoping someone can help me figure out what is going on here.

I have a SQL table in which trying to count rows by month. When I select group by date/time and month in metabase, the counts are incorrect. Data for the current month doesn’t even seem to be counted. When I switch to grouping by day, the information is there and attributed to the correct day.

I have searched around for a solution, but I’m coming up short. Can anyone point me in the right direction?

Can you provide more details about your environment, database, and timezone settings? Thanks!