Skip to main content
Question

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

  • January 8, 2019
  • 0 replies
  • 52 views
Hi, How can I add a dynamic filter with month name (January, February, etc) that has the calendar order and not alphabetical order?
      This topic has been closed for replies.

      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.
      Terms & ConditionsAccessibility statement