Parse date and convert to proper dateTime

[BonusCup]

Hi,

Please see table below.  I have data that comes in as the example 'OriginalData' column but would like to convert the datetime from the original to the "Desired" format and keep all other cells.  I tried using the "DateTime" connector but had no luck.

OriginalData	Desired
Thu Aug 1 01:55:10 EDT 2019 :	08/01/2019 1:55:10
cell 1	cell 1
cell 2	cell 2
cell 3	cell 3
cell 4	cell 4
cell 5	cell 5
Thu Aug 1 03:55:08 EDT 2019 :	08/01/2019 3:55:08
cell 6	cell 6
cell 7	cell 7
cell 8	cell 8
cell 9	cell 9
cell 10	cell 10

Appreciate any help.

[Jean-Balteryx]

Hi @BonusCup  !

I built a workflow using the DateTime tool to convert your string date in standard date format.

I attached the example workflow.

Don't hesitate to ask for more details.

Have a great day !

[JoeS · Accepted solution]

Hi @BonusCup 

Please find attached a workflow that looks to achieve it using a formula tool:

Edit: this community is so quick, by the time you finish your reply you are often beaten too 🙂

[BonusCup]

Thank you @Jean-Balteryx and @JoeS 

Both worked to convert to the correct dateTime but I used @JoeS solution because I needed to keep the cells between each dateTime.

[Jean-Balteryx]

@JoeS 's solution is actually better than mine ! 🙂

[JoeS]

Always nice to have two options available when it comes to working with dates!