This content has been marked as final. Show 4 replies
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.