https://community.qlik.com/t5/Connectivity-Data-Prep/date-conversion-UTC-1/m-p/2044114#M12023 <P>Your number seems to be a&nbsp; unix epoch date.</P> <P>The usual translation is&nbsp;</P> <P>TimeStamp(Makedate(1970,1,1)+ <STRONG>1675495380</STRONG> /24/60/60 , 'YYYY-MM-DD hh:mm:ss')<BR /><BR />you can validate here&nbsp;<A href="https://www.epochconverter.com/" target="_blank">https://www.epochconverter.com/</A>&nbsp;</P> Wed, 01 Mar 2023 20:56:08 GMT Clever_Anjos 2023-03-01T20:56:08Z https://community.qlik.com/t5/Connectivity-Data-Prep/date-conversion-UTC-1/m-p/2044042#M12022 <P>Hello,</P> <P>I have problem, because I need to convert date. I have this date&nbsp;1675495380&nbsp;what corresponds&nbsp;<SPAN>2023-01-31 16:00.</SPAN></P> <P>My time zone is Warsaw</P> <P>&nbsp;</P> <P>What I should do?&nbsp;I need any advice</P> <P>&nbsp;</P> Wed, 01 Mar 2023 17:58:08 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/date-conversion-UTC-1/m-p/2044042#M12022 Isabelaa_123 2023-03-01T17:58:08Z https://community.qlik.com/t5/Connectivity-Data-Prep/date-conversion-UTC-1/m-p/2044114#M12023 <P>Your number seems to be a&nbsp; unix epoch date.</P> <P>The usual translation is&nbsp;</P> <P>TimeStamp(Makedate(1970,1,1)+ <STRONG>1675495380</STRONG> /24/60/60 , 'YYYY-MM-DD hh:mm:ss')<BR /><BR />you can validate here&nbsp;<A href="https://www.epochconverter.com/" target="_blank">https://www.epochconverter.com/</A>&nbsp;</P> Wed, 01 Mar 2023 20:56:08 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/date-conversion-UTC-1/m-p/2044114#M12023 Clever_Anjos 2023-03-01T20:56:08Z