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 ? 🙂
Solved! Go to Solution.
Thanks 🙂