Forum Discussion
DateTime Conversion
Hello All, I am getting data from an API using powerquery. Result is a JSON file which we are expanding into columns. One of the column is CreateDate which is of format "yyyy-MM-DDTHH:MM:SS.ms" ...
Anonymous , try if you can use DateTime.FromText in new column.
This should take this time as per example in
https://docs.microsoft.com/en-us/powerquery-m/datetime-fromtext
else replace T using Text.Replace
example
DateTime.FromText (Text.Replace([DT], "T", " "))
amitchandak
Super User
Super UserAnonymous , try if you can use DateTime.FromText in new column.
This should take this time as per example in
https://docs.microsoft.com/en-us/powerquery-m/datetime-fromtext
else replace T using Text.Replace
example
DateTime.FromText (Text.Replace([DT], "T", " "))