DateTime from Custom format

[BonusCup]

Hi,

I'm bring in data with dateTime formats like below.  I've tried the DateTime tool but not sure how to enter the last ":000" before AM/PM

Jul  6 2020  4:50:00:000PM

Jul  6 2020 11:01:26:000AM

[JosephSerpis · Accepted solution]

Hi @BonusCup I mocked up a workflow let me know what you think?

[BonusCup]

@JosephSerpis 

Well, that was an extremely fast solution.  Thanks so much!  I was trying to figure out some regex and wasn't having luck there either.

Thanks again!