yyyymmdd to dd-month-yyyy conversion

[keerthanak222]

I have my source date data in the string format "20130101" i wanted to convert it to 01.Jan.2013 format when i use the formula DateTimeParse([_CurrentField_],"%d-%b-%Y") in Multi Field formula after changing data type to date it is showing me the below error

ConvError: Multi-Field Formula (17): DATETIMEPARSE: Error in DateTimeParse: Month number is out of range 1..12

How to achieve this conversion

[hedouard]

@nick_schimweg Thank you.  That was exactly what I was looking for.  The substring formula was very helpful