ToNumber(substring....

[ohruud]

Hi there, 

I have a data-set containing months as a string function (Jan, Feb, Mar etc), but not in the right order. One solution that I found was to give each month a number, thus enabeling to sort on nuber to get the right order. 

The expression used was " ToNumber(substring(DateTimeParse([month], "%b"),5,2))

However, I do not fully understand how the formula works.  Can someone explain ? 🙂

[DavidP · Accepted solution]

If you break it up into individual parts, it's easier to understand the formula, see below:

[ohruud]

Thanks 🙂