Forum Discussion

Regular Visitor

10 years ago

Convert date ticks to DateTime

I have seen this formula in another post. Convert(datetime, (MachineGroups.TimeAdded - 599266080000000000)/864000000000) Power BI doesn't have the convert function. Can any one write this...

hugoberry

Responsive Resident

9 years ago

Try the following conversion

=DateTime.FromFileTime([ticks])-#duration(584388,0,0,0)

The FromFileTime counts the ticks from 1600/01/01 so that's why we have the duration of 584388 days to offset this.

Forum Discussion

Convert date ticks to DateTime

Related content

Convert DateTime to Date

Convert Ticks timestamp to datetime - Power Query

Converting Epoch Datetime into regular datetime format

Convert C# date ticks to DateTime

Convert bigint to datetime