Sorting Months Chronologically not Alpha

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a formula text field that I created from a date field. The formula text field displays the Month and Year generated by the date field. i.e. 3/1/2017 becomes March 2017. I am using the March 2017 field in reports, but can't sort chronologically. 
Photo of Melissa Freel

Melissa Freel

  • 102 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Can you have the sort by the [date] field, even though its not in the report?