I have a date field that auto-fills with current date.
User can change the date, but we want it to be limited to only days in the current week or the previous week.
I built a quick table for day and stuffed a field with all the valid date for selection in a drop down.
BUT... the way I did it the dates will not list with the proper sort order.
I prefer not to have to create a record for each date.
Any recommendations would be appreciated.