Date parse without delimiters

[Belletmns]

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!

[MarqueeCrew · Accepted solution]

@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

[Belletmns]

Wow! Thank you for the swift response! 

[MarqueeCrew]

@Belletmns ,

 you're quite welcome.  

cheers,

 mark