I hope get some enlightenment here because I am trying to convert a string (ddMMyyyy) to a datetime but failed.
The string split from a file name (eg: Sp_12112019.eml) I managed to assign the “ 12112019 ” portion into a separate string called str_date, then when I tried to convert it into a dateTime format, I cannot find a way out.
You can convert it using the below code, use An assign activity and place this code in the right side of that activity, declare a string variable and hold the value from the below line of code.
If you want some other output date format, then change this format as you want “dd-MM-yyyy”