Hello experts,
I am using Metabase with an sql database CRM system.
And when I filter for spesific rows where a certain datefield is < relativeDateTime(-1, "year") I get 50% of the results I get when doing the filtering in CRM, but when I use formula: < date("2024-06-04") I get them all as I should. So the error is in the relativedatetime formula, but it looks fine to me syntax wise.
Can anyone help me understand why this is, and how could I fix this?