Alteryx Designer Desktop Discussions

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

Date parse without delimiters

Belletmns
8 - Asteroid

Hi Team,

 

I need your support please, how should I parse this type of date without delimiters in place:

 

Input:

Start DateEnd Date
2020063020200630
2020052820200528
2020061120200611

 

My Output should be:

Start DateEnd Date
30-Jun-2030-Jun-20
28-May-2028-May-20
11-Jun-2011-Jun-20

 

Thank you!

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Belletmns 

 

https://community.alteryx.com/t5/Engine-Works/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/ba-p/...

 

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.
Belletmns
8 - Asteroid

Wow! Thank you for the swift response! 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Belletmns ,

 

 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.
Labels
Top Solution Authors