Forum Discussion
Helper ITime Stamp to Date
Good morning to all!!!
A simple one, I´m receiving this time stamp and I need to change it to date:
Time Stamp:1551876131000+0100
Human Date: 06/03/2019 9:07:00
I all ready have in one column this part: #datetime(1970,1,1,0,0,0) but I´m not sure how to move forward
I think Ive got it. try a custom column (PPower Query Editor mode)
a) if you have a format time stamp like 1551876131000+0100
= #datetime(1970,1,1,0,0,0)+#duration(0,0,0,Number.RoundDown(Number.FromText(Text.BeforeDelimiter([Time Stamp],"+"))/1000))b. if you have a format time stamp like 1583766096983
= #datetime(1970,1,1,0,0,0)+#duration(0,0,0,Number.FromText([Time Stamp])/1000)
6 Replies
- Greg_Deckler
Community Champion
What sort of timestamp is that, unix?
Perhaps this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Unix2UTC-and-UTC2Unix/m-p/620012#M292
AHMHi
I´m not sure what you mean by Start point, I got this result from an API: /Date(1551876131000+0100)/ and by using split column i got: 1551876131000+0100
In the API document I was able to find this lines that may help to answer the question:
JSON
"DateAndTime":"\/Date(1583766096983)\/
XML
<DateAndTime>2020-03-09T15:01:36.983976Z</DateAndTime>
I this helpfull?
- az38
I think Ive got it. try a custom column (PPower Query Editor mode)
a) if you have a format time stamp like 1551876131000+0100
= #datetime(1970,1,1,0,0,0)+#duration(0,0,0,Number.RoundDown(Number.FromText(Text.BeforeDelimiter([Time Stamp],"+"))/1000))b. if you have a format time stamp like 1583766096983
= #datetime(1970,1,1,0,0,0)+#duration(0,0,0,Number.FromText([Time Stamp])/1000)
