Filtered Value List or Omit Duplicates
I am working on a Staff roster Database and am wanting to show a list with the "shift date" from the Table:Shifts that is sorted in Descending order and only shows the last 2 months. I have it as a drop down value list using values from field: Shifts::Date, but this is naturally sorted in Ascending order and will end up showing a lot of old shift dates. Is there anyway to evoke the Specify Calculation Box here?
My other thought was to have it as Popover button with a Portal in and a TO relationship Shifts and Shifts2, with this I have the portal sorting and can filter the last 60 days, but I don't know how to filter the duplicates, as many shifts in a week have the "same date".
Can you help me with either one of these options? Thanks in advance.