Forum Discussion

bourne2000's avatar
bourne2000
Helper V
4 years ago
Solved

Convert timestamp into date/time

Hi   I am having the below timestamp     I tried the below formula   #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0,[create_date]/1000)     I am getting the below error   ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bourne2000 ,

     

    Accroding to the error message, you will need to change the data type of [create_date] to whole number then use the formula.

    #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [create_date]/1000)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi bourne2000 ,

 

Accroding to the error message, you will need to change the data type of [create_date] to whole number then use the formula.

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [create_date]/1000)

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Jay,

 

Thanks for your post. I try the solution, and it works. But, why 1970? The date since not appropriate...