Calendar month text field sorting

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Acknowledged
I'm working with a text multiple choice field that is used to choose a month of the calendar year. The months are listed as the options in the dropdown and I've chosen for them to 'Sort in this order', so they will sort January-December. This works fine while using the field to sort reports. But when used a Dynamic Filter this field defaults to sort alphabetically. Is there a way to force it to sort January-December?

Thanks!
Photo of Heather Bryant

Heather Bryant

  • 994 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
A worka round is to create a new formula text fields use as a Dynamic Filter which will result in values like

1-Jan
2-Feb
Etc
12-Dec

You would need to have a leading space in front of the months from1-9