Forum Discussion

AHM's avatar
AHM
Icon for Helper I rankHelper I
6 years ago
Solved

Time 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...
Need Help
Show and Tell
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    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)

     

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
AHM
Icon for Helper I rankHelper I
6 years ago

Worked Perfectly!!!