I’m trying to get just the year in the following table with timestamps. Which is usually possible using Year(), but somehow I can’t get it to work on query selection criteria thing:

I tried to cast Year() on the trigger but it still shows the entire thing. Here’s the query:

SELECT 
    Year(A."DocDate") as "Years"
FROM 
    OPCH A
WHERE
    Year(A."DocDate") = Year([%0])
GROUP BY
    Year(A."DocDate") 

I wish I could try to make a new table for it but my license didn’t allow me to. I just want it to have like dropdowns or just show years of available. I’ve tried Year([%0]), Extract_year and just plain [%0], but none of them work. Is the issue with the query or something else?