Whenever I try to filter the date in a new question (apparently saved ones do it the proper way), the behaviour of “<=” is actually “<” as shown in the screenshots below.
Does the date without explicit time of the day considers the first minute of it and though none of my transactions get retrieved in the query?
Which version of Metabase?
Which database are you querying?
When using a plain query (without any filters/parameters), then the SQL is just transferred to the database without any modification, so the query should run exactly like it does on your database (except for added
ca.created_at is a
DateTime column, then you need to convert/cast it as
Date, otherwise it’s just reading it like
ca.created_at <= '2019-05-31 00:00:00'
Casting it solved the problem.
Thank you for your answer.