Forum Discussion
AHM
Helper I
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 on...
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)
AHMHelper I
Helper IHi
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
Community Champion
Community ChampionI 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)
- AHM
Worked Perfectly!!!