Conversion problems string to datetime not suitable format

[Karlygash]

Hello, dear KNIME users!

I have problem with converting string data into date time format
Used several patterns such as: mm/dd/yy hh:mm:ss A, MM/dd/yy HH:mm aa
But seems like they are not appropriate for my date time format
It looks like this

Can you help me convert these data types into datetime, please
to_Send.xlsx (30.5 KB)
I have attached input file as well)

[ipazin]

Hello @Karlygash,

Use following format for Start/End columns:
MMM d, yyyy h:mm a

For Apply column you’ll have to use another String to Date&Time node. You should be able to figure format yourself

Br,
Ivan

[Karlygash]

thanks for help!

[mlauber71]

@ipazin

MMM d, yyyy h:mm a

That is great. I added this to the collection of ‘messy’ AM/PM Date&Time formats in my collection:

Deal with (messy) Time formats containing AM/PM distincions – mlauber71