Date Time format

[AKPWZ]

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 solution]

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

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

[ShankerV · Accepted solution]

Hi @AKPWZ 

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

Many thanks

Shanker V

[AKPWZ]

Thank you @DataNath It works for me :)

[AKPWZ]

Thank you @ShankerV It works for me