Relative datetime formula bug?

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?

What dates are missing exactly? Were you able to identify that? .. Can you also share some screenshots