Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

ToNumber(substring....

ohruud
7 - Meteor

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 ? 🙂

 

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

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

 

DavidP_0-1587722978264.png

 

ohruud
7 - Meteor

Thanks 🙂

Labels
Top Solution Authors