I have a character field containing dates in format "DD-MON-YY", i.e. "12-Jan-03".

Has anyone got an easy answer to indexing this field in date order of year-month-day. Is there a function to convert i.e "Jan" to "01", "Feb" to "02" etc.?

Regards

Jeff