Forum Discussion
Create function to convert Epoch date to DateTime format
Hi, I am using a Odata service which always display date and date time data in Epoch format like this (examples) For a Date field: /Date(-2208988800000)/ For a DateTime field /Date(1643042...
Overhead of a function is not needed in this case when you can do it with a formula
= #datetimezone(1970,1,1,0,0,0,0,0) + #duration(0,0,0,Number.From(Text.Start(Text.BetweenDelimiters([EpochDate],"(",")"),10)))
Overhead of a function is not needed in this case when you can do it with a formula
= #datetimezone(1970,1,1,0,0,0,0,0) + #duration(0,0,0,Number.From(Text.Start(Text.BetweenDelimiters([EpochDate],"(",")"),10)))So easy! Thanks