date conversion UTC+1

[Isabelaa_123]

Hello,

I have problem, because I need to convert date. I have this date 1675495380 what corresponds 2023-01-31 16:00.

My time zone is Warsaw

What I should do? I need any advice

[Clever_Anjos · Accepted solution]

Your number seems to be a  unix epoch date.

The usual translation is 

TimeStamp(Makedate(1970,1,1)+ 1675495380 /24/60/60 , 'YYYY-MM-DD hh:mm:ss')

you can validate here https://www.epochconverter.com/