In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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