Sort on Month Name (Text Data Type)

Topic

New Reply

I am looking for some assistance. My data is pulled from excel and brings in the “month” as the word January, February, March etc as text data type. I need to sort on this field but being text it doesn’t work. How can I either turn this into a date or perhaps convert the words to a number for sorting purposes.

Hope that makes sense??

Thanks in advance

Kerry

Reply | Quote

Replies

Two things I can think of.
Import the data as a number and convert when it’s displayed.
Add a field “MonthNo” that matches the month field, retrieve that along with the data and sort on it but do not display it. You can populate the field when you import the data.

cheers, Paul

Reply | Quote

Or, there is this. Let’s suppose your fieldname is “MonthName”. You could sort by this expression:

Month( [MonthName] & ” 1″)

Reply | Quote

Mark, sorry for my ignorance, but how would I sort using an expression?
My fieldname is —

Month([Previous Discharge Date (Month)] & ” 1″)

Reply | Quote