SOLVED
ToNumber(substring....
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ohruud
7 - Meteor
‎04-24-2020
02:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Date Time
2 REPLIES 2
17 - Castor
‎04-24-2020
03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-24-2020
03:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks 🙂
