Forum Discussion
Solved
Convert Ticks timestamp to datetime - Power Query
Good afternoon Power Community, I am connected to a Azure SQL server. I am getting a time stamp in Ticks was woundering if anyone knew how to convert it to datetime? An example of what is in ...
Sorry for the slow reply and thank you for all of your replies edhans Anonymous. I tried a number of options and the following is how I got it to work:
I created a custom columns and used the following code:
DateTime.FromFileTime([Created At])-#duration(584388,0,0,0)I found this here: Solved: Convert C# date ticks to DateTime - Microsoft Power BI Community
Sorry for the slow reply and thank you for all of your replies edhans Anonymous. I tried a number of options and the following is how I got it to work:
I created a custom columns and used the following code:
DateTime.FromFileTime([Created At])-#duration(584388,0,0,0)
I found this here: Solved: Convert C# date ticks to DateTime - Microsoft Power BI Community
