Converting month names to actual months

62 Views Asked by At

Sorry for the odd title, not sure how else to summarize the issue.

I'm working with Report Designer 1.0 in SSRS 2005.

I have month names (e.g. January, February, etc) that I have extracted from a longer string that I am using in a 'Month' column of a table using this in the Edit Expression box:

=Mid(Fields!DESCRIPTION.Value, InStrRev(Fields!DESCRIPTION.Value, " ") + 1)

I now need to put the months in chronological order. Can anyone help?

Many thanks, Jens

0

There are 0 best solutions below