Hi everyone,
When I use the Month and Year Date Filter for a month, I don’t get the results for the last day of the month.
For example :
- If I select january 2019, I get the results from 1st to 30th january
- if I select february 2019, I get the results from 31st january to 27th february
I’m using metabase V0.31.2.
Thanks in advance
It will depend on your DB but as a work around I tend to use something along the lines of
where
date between {{start}} and ({{end}} + interval 1 day)
Livier
5
Thank you all for your answers.
I will try to look at the timezones issue
Livier
6
Thank you @flamber
I change my time zome and it works now
1 Like