Time Stamp to Date

[AHM]

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

[az38]

@AHM 

what is the start point for this time stamp. it doesnt look like Unix  time

[AHM]

Hi

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 · Accepted solution]

@AHM 

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)

[AHM]

Worked Perfectly!!!

[Greg_Deckler]

OK, unless I am mistaken, that is a Unix timestamp in milliseconds. This means that the start point is January 1st, 1970. You could use the quick measures I posted, just have to divide the value by 1000 first.

[Greg_Deckler]

What sort of timestamp is that, unix?

Perhaps this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Unix2UTC-and-UTC2Unix/m-p/620012#M292