Sorting by month is hard when they begin with the month name. Instead sort by year month:
What's the best data type to store those months?
Should I store them as text or date?
If I store the data as text then won't it be hard to create reports etc.. Like summary for every year, or summary for every quarter etc..?
1 of 1 people found this helpful
Use a date field where a value such as 12/1/2016 but formatted to display as shown in your original post. Don't use a value list for selecting the date. Use a selection portal inside a popover to get the values sorted and formatted the way that you want. (A deployable button bar could also be used.)
Thank you philmodjunk.