Conversion problems string to datetime not suitable format

Hello, dear KNIME users! :smiling_face_with_three_hearts:

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
image
Can you help me convert these data types into datetime, please
to_Send.xlsx (30.5 KB)
I have attached input file as well)

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 :wink:

Br,
Ivan

6 Likes

thanks for help! :smiling_face_with_three_hearts:

1 Like

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

5 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.