Dates by YEAR defaulting to 2019

I have a SQLITE datasource, dates are stored as ISO date string (YYYY-MM-DD HH:MM:SS.SSS). Building a query which groups by one of these date fields “binned” by month works fine. However, binning by YEAR returns multiple ‘2019’ for each year permutation in the dataset.

Metabase: 34.0
OS: CentOS

Hi @brianwilson
Interesting bug. I haven’t figured out where the problem is (if it’s a driver issue or something in Metabase).
I guess your only workaround is to create the query in SQL.
I’ve created an issue for this: - upvote by clicking :+1: on the first post