No result for filetering Date


I found Metabase, and easy to install, easy to play with... but, more complex with use of dates.

My objective is to get some results when i filter a date column, like "yesterday", or "Last month" etc like :

but No result :

So... i ved read this forum...

  • I tried some change of parameters in the Admin panel :

  • I tried also to setup Timezone, like lot of posts and answers precise it :

java -Duser.timezone="Europe/Paris" -jar metabase.jar

  • I tried also to change type of date (without really now the impact of this change, because, a date is a date)

But always ** NO result !**

For information, the origin of datas is a CSV file, imported in SQL Lite via SQLlite studio.

Could you help me please ?

I send you a sample of my datas :

and, Informations de diagnostic :

"browser-info": {
"language": "fr",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0",
"vendor": ""
"system-info": {
"file.encoding": "Cp1252",
"": "Java(TM) SE Runtime Environment",
"java.runtime.version": "16.0.2+7-67",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "",
"java.version": "16.0.2",
"": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "16.0.2+7-67",
"": "Windows 10",
"os.version": "10.0",
"user.language": "fr",
"user.timezone": "Europe/Paris"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
"run-mode": "prod",
"version": {
"date": "2022-06-13",
"tag": "v0.43.3",
"branch": "release-x.43.x",
"hash": "c9c7ef0"
"settings": {
"report-timezone": "Europe/Paris"

Hi @Yoann
Are you sure that those columns are actually DATE types in SQLite?
It looks like it is strings, which would require you to convert the data yourself.
SQLite is different than most databases and allows some strange values in certain column types, which is not recognized by other systems.

Hi @flamber

Thanks for this feedback.

I don't list it, but i ved also make the change of format in DATE in SqlLite, and I just unmake this change.
So, if its database problem, I will change it...
But, for you, what is the best process to do, from a CSV as origin ? and success to update recursivly by a new CSV file ?

@Yoann The best process is to make sure that dates in a database is always YYYY-MM-DD, which is universal for computers and something that can be worked on. So change your data in CSV before importing it, and make sure that your column types in the database are as correct as possible (use DATE for dates, etc).