Discussions

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!

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