String to DateTime - Datetime tool only converting some values

[wonka1234]

hi,

I have this data set column as a string, i want to convert it to date.

27SEP2023:10:11:45.898612
22SEP2023:08:50:58.710292
04OCT2023:20:47:22.229669
19SEP2023:12:57:18.044111 

date time tool i use this - ddMMMyyyy:hh:mm:ss.ssssss

only 1 of these values are converting, please help.

[OTrieger]

@wonka1234 
Have you tried ddMMyyyy:hh:mm:ss.ssssss?

[wonka1234]

@OTrieger  "ddMMyyyy:hh:mm:ss.ssssss" seems to give all nulls :(

[ChrisTX · Accepted solution]

Use ddMMMyyyy:hh:mm:ss.ffffff

See the section for "Hour, Minute, and Second Format Specifiers" on this web page:   DateTime Tool (alteryx.com)

Chris

[OTrieger]

You actually need to use this format: ddMonyyyy:hh:mm:ss

[OTrieger]

This one will work