Drop down menu question
I have a drop down menu that I use for "user input" creation of a report.
The field allows the user to select a month and generate a report, it populates a global field.
I want the field to say January 2015, although that doesn't work for the search so I use a table for the value list and show only the second field (first field 1/2015 - second field January 2015). That works, however the list is sorted alphabetically and I want it sorted chronologically? Thoughts?