Hi, How can I add a dynamic filter with month name (January, February, etc) that has the calendar order and not alphabetical order?

Create a formula ltext field similar to this one, but instead of what I have herenumber the months, like


1. JAN

2. FEB


var date MyDate = [ETA Date Current for whole order complete];


Case(Month($MyDate),

1," 1. JAN",

2," 2.FEB",

Etc


11,"11. NOV",

12,"12. DEC")


Note that I have added an extra space In front of the Kitchen months to ensure the storage before November and December.