Converting string to month

[#1]

Hi,

Is it possible to convert the string into Month. I have a column with string values like Jan-10,Feb-10.... I am trying to sort it in the original order as Jan,Feb ... in the bar chart. Since it is string the same can be done by converting the values to date format. Is there any other way to acheive this without changing the database level(Since huge data is there).

[#2 · Accepted solution]

You need to use Date# function

In your example it should be date#(MyField,'MMM-YY')

Rgds,

Sébastien

[#3]

Thanks Sebastien,

It is working fine as expected.

[#4]

Great !