Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper 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

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago

PC2790 I tried to convert into date. Getting the below error

 

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
1652810074075

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

What is the source of your data?

can you check if it is fine at the source? Also, is the Locale of your source and Power BI dekstop same?