https://community.qlik.com/t5/Talend-Studio/Epoch-conversion/m-p/2489125#M141456 <P>=num(date(today(1)))*86400000 - num(date('1/1/1970'))*86400000</P> <P>This will give you epoch time in milliseconds for a specified date. Qlik is storing dates as the number of days passed from 1/1/1900, whereas epoch time starts from 1970. Converting the date to milliseconds, and subtracting 1970, will give you the correct epoch time.</P> <P>&nbsp;</P> <P>From&nbsp;&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Dev/Calculate-epoch-time-milliseconds/m-p/1251009/highlight/true#M395928" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Calculate-epoch-time-milliseconds/m-p/1251009/highlight/true#M395928</A></P> <P>&nbsp;</P> Fri, 25 Oct 2024 08:57:48 GMT p_verkooijen 2024-10-25T08:57:48Z https://community.qlik.com/t5/Talend-Studio/Epoch-conversion/m-p/2489122#M141455 <P>How to convert a date from epoch (milliseconds) to date</P> <P>&nbsp;</P> Fri, 25 Oct 2024 08:47:09 GMT https://community.qlik.com/t5/Talend-Studio/Epoch-conversion/m-p/2489122#M141455 Paolo_SMC 2024-10-25T08:47:09Z https://community.qlik.com/t5/Talend-Studio/Epoch-conversion/m-p/2489125#M141456 <P>=num(date(today(1)))*86400000 - num(date('1/1/1970'))*86400000</P> <P>This will give you epoch time in milliseconds for a specified date. Qlik is storing dates as the number of days passed from 1/1/1900, whereas epoch time starts from 1970. Converting the date to milliseconds, and subtracting 1970, will give you the correct epoch time.</P> <P>&nbsp;</P> <P>From&nbsp;&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Dev/Calculate-epoch-time-milliseconds/m-p/1251009/highlight/true#M395928" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Calculate-epoch-time-milliseconds/m-p/1251009/highlight/true#M395928</A></P> <P>&nbsp;</P> Fri, 25 Oct 2024 08:57:48 GMT https://community.qlik.com/t5/Talend-Studio/Epoch-conversion/m-p/2489125#M141456 p_verkooijen 2024-10-25T08:57:48Z