Convert UTC MilliSeconds DateTime to DateTime format only

[TanLC]

Hi, in my file, there's a DateTime column with UTC MilliSeconds & I would like to convert it into DateTime format only without the UTC MilliSeconds either using SQL or Power Query.

Please help.

"2024-10-17T07:19:28.9700000" to "17/10/2024 07:19:28 AM"

Thank you.

Regards,

Tan LC

[Anonymous]

Hi @TanLC ,

Did you find a solution? Did the answers help? If so, mark the reply as a solution, which will help the next user with a similar problem, thank you~!

Best Regards,
Gao
Community Support Team

[ZhangKun]

= DateTime.ToText(DateTime.FromText("2024-10-17T07:19:28.9700000"), [Format = "MM/dd/yyyy hh:mm:ss tt", Culture = "en-US"])

[Omid_Motamedise · Accepted solution]

Hi @TanLC 

use the below formula

= DateTime.ToText(DateTime.FromText(Text.Start("2024-10-17T07:19:28.9700000", 23)),"dd/MM/yyyy hh:mm:ss tt")