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

PC2790's avatar
PC2790
Community Champion
4 years ago

Hey bourne2000 ,

 

As per te error, it is not letting a text field to be divided by 1000. So - [create_date]/1000 woun't work.

Did you try converting the datatype by selecting the ABC adjacent to column name and selecting date there?