Forum Discussion
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
Can anyone advise me how to do this?
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
5 Replies
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
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?
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:
1652810074075What 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?
