Convert UTC Date Time to Alteryx Date and time format

[JenzEkan]

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

[grazitti_sapna · Accepted solution]

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

[ShankerV]

Hi @JenzEkan 

One way of doing this!!!!

Many thanks

Shanker V

[ShankerV]

Hi @JenzEkan 

Step 1: Input

Step 2: 

Step 3: 

Many thanks

Shanker V

[ChrisTX]

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

[JenzEkan]

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