4 Replies Latest reply: Feb 12, 2013 7:00 AM by Stefan Wühl RSS

    Sorting Date output in correct order

      Hello, I am trying to sort the presentation of a date in the correct order which im struggling with.

       

      I am using the code :- month(Posting_Date)&' '&chr(39)&right(Posting_Date,2) as Posting_Month so that if there is a date of 12/07/2011 it will be presented as Jul '11.

       

      I have under the presentation tab hit Dropdown select and all the months are in a random order and i've no idea how to sort them into correct order.

       

      Any ideas?

       

      Paul.