https://community.incorta.com/t5/dashboards-analytics-discussions/how-do-i-convert-epoch-time-to-a-date/m-p/283#M9 <P><SPAN>The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds. (More info at&nbsp;</SPAN><A href="https://www.epochconverter.com/)" target="_blank" rel="nofollow noopener noreferrer">https://www.epochconverter.com/)</A><BR /><BR />You can use the following formula:</P> <P><EM>addSeconds(date('1970-01-01'), [Insert EPOCH field here]/1000)</EM></P> Wed, 19 Jul 2023 15:50:09 GMT amit_kothari 2023-07-19T15:50:09Z https://community.incorta.com/t5/dashboards-analytics-discussions/how-do-i-convert-epoch-time-to-a-date/m-p/282#M8 <P><SPAN>What is Epoch time and how do I make it readable in my insight?<BR /></SPAN></P> Wed, 09 Mar 2022 21:49:57 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/how-do-i-convert-epoch-time-to-a-date/m-p/282#M8 amit_kothari 2022-03-09T21:49:57Z https://community.incorta.com/t5/dashboards-analytics-discussions/how-do-i-convert-epoch-time-to-a-date/m-p/283#M9 <P><SPAN>The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds. (More info at&nbsp;</SPAN><A href="https://www.epochconverter.com/)" target="_blank" rel="nofollow noopener noreferrer">https://www.epochconverter.com/)</A><BR /><BR />You can use the following formula:</P> <P><EM>addSeconds(date('1970-01-01'), [Insert EPOCH field here]/1000)</EM></P> Wed, 19 Jul 2023 15:50:09 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/how-do-i-convert-epoch-time-to-a-date/m-p/283#M9 amit_kothari 2023-07-19T15:50:09Z