Convert UNIX timestamp to Date time

[samsamsam]

Hi, 

I am trying to convert a UNIX time to normal date time display

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

However, it returns the year in Jan 1970. But the month and year should be Jun 2019. 

Do I make any mistake here?

Thanks in advance

Sam

[Gordonlilj · Accepted solution]

Hi,

Try removing the /1000 part of the code

[samsamsam]

@Gordonlilj it works perfectly , thank you~😁