0

Custom column - EPOCH Date

Hi all - Has anyone created a custom column to convert an epoch timestamp into UTC a regular timestamp.  I've found several examples like #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, <epochstring>) but I receive an invalid expression error.  

Thanks!

1 reply

null
    • Dvir_Buzaglo
    • 6 yrs ago
    • Reported - view

    Hi Bryan,

     

    I've found a way to inject the Epoch time to a custom member ,

    Please follow the next steps:

    Create a new custom member and insert the Epoch time to the highlighted part.

    Format(DATEADD("s", 1514890406,"1970/1/1 00:00:00"),"yyyy-MM-dd hh:mm:ss")          

                      

    You can find more information about the subject :

    Dateadd function

    Date and time formats

     

    Hope it helps.

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 1Replies
  • 90Views
  • 3 Following