Convert string to datetime

[Carrie_]

I have tried and failed many ways attempting to convert my timestamp. I am inputting a csv file, so I need to convert from a string to a datetime field. The format is "07JUN2019:12:56:13.000"

Thanks!

[JosephSerpis · Accepted solution]

Hi @Carrie_ try this syntax  DateTimeParse([Test],"%d%b%Y:%H:%M:%S") in a formula tool and select a datetime field and replacing the [Test] field.