Using FROM_UNIXTIME Correctly

Hello,

 

I think this problem is an easy fix, but it has proven difficult for me. I've imported some data from Hubspot about my contacts, and I'm trying to convert one column from UNIX into a human readable time using a calculated field. (I validated it before and Domo said it was good to go).

 

This is my formula: DATE_FORMAT(FROM_UNIXTIME(`Became a Lead Date`), '%m,%d,%y')

 

What I get is shown in the attached image.

 

Anyone know what I did wrong?

Best Answer

  • Property_Ninja
    Accepted Answer

    ahhhhhh okay, try this to convert it in Beastmode. If it doesn't work in Beastmode you will have to cast it as a BIGINT in a dataflow transform.

    from_unixtime(yourDate/1000)

     

    -Brian

Answers