Forum Discussion
Convert C# date ticks to DateTime
I am sure you could do it in Power Query.
Read this. http://stackoverflow.com/questions/1489243/how-can-i-convert-ticks-to-a-date-format
in Power Query, add a new column and then use the formula, above to convert the date tick to a serial number
I think you can then convert the number to a date with the UI (although I have never tried it). Worst case you should be able to use a power query date fipunction to convert it.
Thanks Matt. I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.
I am sure you could do it in Power Query.
Read this. http://stackoverflow.com/questions/1489243/how-can-i-convert-ticks-to-a-date-format
in Power Query, add a new column and then use the formula, above to convert the date tick to a serial number
I think you can then convert the number to a date with the UI (although I have never tried it). Worst case you should be able to use a power query date fipunction to convert it.
Thanks Matt. I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.