Date Time format

Question

Hi,

Can some please help me how can I get the desired Datetime format out of this "2023-03-27T09:53:55.830084+00:00" (created_datetime)

I tried two things but no luck:

1. ToDateTime([created_datetime]) => using formula tool

2. Custom => %Y-%m-%dT00:00:00.000Z => Using Date Time tool

Desired Output:
2023-03-27 09:53:55

Thanks

DataNath · Accepted Answer

Hey @AKPWZ, can you try using a Formula tool with the following expression:

DateTimeParse([Input],'%Y-%m-%dT%H:%M:%S')

ShankerV · Accepted Answer

Hi @AKPWZ

Owe way of doing this with the help of Date time tool.

Many thanks

Shanker V