Convert UTC Date Time to Alteryx Date and time format

Hey Alteryxians,

I have a query in which I need to convert the below format dates to Alteryx dates. Please provide some inputs to achieve it.

Sample Input:

2022-04-18T21:21:56.000+0000
2021-03-02T00:00:00.000+0000
2022-08-10T07:03:53.000+0000
2022-08-10T07:03:54.000+0000
2022-09-01T14:41:43.000+0000

Date Time

Accepted answers

Hey @JenzEkan , You can use the below custom format using DateTime tool:

Hey @JenzEkan , You can use the below custom format using DateTime tool:

One way of doing this!!!!

Many thanks

Shanker V

Step 1: Input

Step 2:

Step 3:

Many thanks

Shanker V

Are your last two time segments always .000+0000 ?

If yes these formulas should work:

Replace([F1], "T", " ") output data type: String

Replace([F1], ".000+0000", "") output data type: String

DateTimeParse([F1],"%Y-%m-%d %H:%M:%S") output data type: DateTime

Chris

Thank you Guys for the quick response @ChrisTX @ShankerV @grazitti_sapna .