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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
Photo of Pablo

Pablo

  • 112 Points 100 badge 2x thumb

Posted 5 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,704 Points 50k badge 2x thumb
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.
(Edited)
Photo of Pablo

Pablo

  • 112 Points 100 badge 2x thumb
Txs very much.
No way to avoid the indexing number at the beginning right?
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,704 Points 50k badge 2x thumb
Dynamic filter sort alphabetically. So if you don’t like the numbering you will just have to add enough spaces in front of each respective months to get them to start properly alphabetically. There is no magic here. It is an alphabetic start.

That answer was dictated so I hope Siri spelled that OK