Month and Year Date filter

#1

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

#2

Hi @Livier
It looks like that might be a timezone issue.
https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html

#4

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)
#5

Thank you all for your answers.
I will try to look at the timezones issue

#6

Thank you @flamber
I change my time zome and it works now

1 Like