Date Part Filter Problem
I have a postgres table with a date column in my data set (mm/dd/yyyy). I"ve added 3 columns to a view by copying this date field. I've applied the Date Part format on these fields in the view and formatted as:
Year, Month, Quarter
When I use these fields in a Report Filter, I get duplicate values in the selection list the filter creates as shown in the attachment, I'm guessing because the underling date is driving the list in the filter, but display by the format.
This is odd, since the field displays the correct format. Is it possible to filter on the desired format while removing dups in the list?