I want to set the default date to, last years today.
Right now, I am using the field filter.
The default date is set as today.
But I also want to compare it with the last years today too.
I know that if you do, -364days from today I can get last years today.
But when it’s the leap year this won’t work.
I am using postgres.
If Metabase or SQL has a solution for my issue, please help me out.