SOLVED
Date parse without delimiters
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
Belletmns
8 - Asteroid
‎10-01-2020
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I need your support please, how should I parse this type of date without delimiters in place:
Input:
Start Date | End Date |
20200630 | 20200630 |
20200528 | 20200528 |
20200611 | 20200611 |
My Output should be:
Start Date | End Date |
30-Jun-20 | 30-Jun-20 |
28-May-20 | 28-May-20 |
11-Jun-20 | 11-Jun-20 |
Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
20 - Arcturus
‎10-01-2020
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DateTimeFormat(
DateTimeParse([Start Date],"%Y%m%d"),
"%d-%b-%y")
and the end date is the same.
cheers,
mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎10-01-2020
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow! Thank you for the swift response!
20 - Arcturus
‎10-01-2020
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you're quite welcome.
cheers,
mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
