Event Dime

Date filter for not working correctly - adjusted UTC + 10

When:

June 16, 2026 · 9:28 PM

Where:

Metabase Discussion

Source:

Metabase Discussion

I am on v0.60.3 This is the SQL from Metbase question SELECT DATE( __mb_source. Invoice Date ) AS Invoice Date, COUNT(*) AS count FROM ( SELECT CAST( DATE_ADD( invoices. created_at, INTERVAL 10 hour) AS date ) AS Invoice Date FROM invoices WHERE CAST( DATE_ADD( invoices. created_at, INTERVAL 10 hour) AS date ) BETWEEN DATE(DATE_ADD(NOW(6), INTERVAL -30 day)) AND CAST(DATE(NOW(6)) AS datetime) AND ( invoices. invoicestype = 'Renewal') ) AS __mb_source GROUP BY DATE( __mb_source. Invoice Date ) OR