Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

14-digits Timestamp wrongly converted

Hi community!   I have been transforming some data in my Power query to create some reports that I need for the univeristy, but I'm struggling trying to convert and 14-digits timestam to datetime: ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Add this custom column, you can do the formatting after loading the query to the model as you need

    =Date.From(Text.Start([Timestamp],8))&Time.From(Text.End([Timestamp],6))

     



collinsg's avatar
collinsg
Icon for Solution Sage rankSolution Sage
3 years ago

A quick way of doing this is to use DateTime.FromText. First change the type of the 14 digit timestamp to text. Then use the format option in the second argument of DateTime.FromText. The formats are described here.

 

= Table.AddColumn(
   #"Name of Previous Step", 
   "Date & Time", 
   each DateTime.FromText( [14 Digit Timestamp], [Format="yyyyMMddHmmss"] ),
   type datetime
)