Forum Discussion
Solved
Convert UTC MilliSeconds DateTime to DateTime format only
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. ...
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")
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