Need help on a sorting requirement:
I have a formula text field that take a calendar date in mm/dd/yyyy format and converts it to a MMM -YYYY (Jan-2014) and inserts TBD if no date is selected. The sort requirement is to push all records with TBD to the bottom of the list so I created a new formula field that inserts a pipe character if the value is TBD like "|TBD". Sorting on this field moves all the records with date = TBD to the bottom of the list. But the problem is that records with dates like Jan-2014, Oct-2014, etc it sorts alphabetically as opposed to calendar month wise like Jan-2014,Feb-2014 etc.
So the sort requirement is to sort records with date values populating the sort field calendar wise (as in Jan, Feb, march, etc) and those records with TBD as a value to be pushed to the bottom of the list.
How would you solve this?