Currently, by using DAY or MONTH, etc it won't give you the exact day you're looking for.
Example: If you run this in Postgres to demonstrate the option you're saying by using DAY - 180
select current_date - INTERVAL '6 months'
, current_date - INTERVAL '180 days'
First column which is true 6 months ago will return 8/5/2024 from today
Second column which is 180 days from the current date (equivalate to DAY in Jasper) will return 8/9/2024
Both days are different so using DAY - 180 will not work.
It would be nice if the Filter or Input control could use the true current date - 6 months to go back to the exact 6 months. That would be applied to Quarter, Year
Sam Gaid
| Components | Filters, Input Controls |
