Convert timestamp into date/time

[bourne2000]

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?

[Anonymous · Accepted solution]

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]

Hello Jay,

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

[bourne2000]

@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]

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?

[PC2790]

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?