topic Re: Date & time convert to Epoch in QlikView https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371601#M822909 <HTML><HEAD></HEAD><BODY><P>try this, make sure that <SPAN style="font-size: 13.3333px;"><STRONG>DateField </STRONG>is in number format</SPAN></P><P></P><P>=Floor((DateField-MakeDate(1970,1,1))*86400)</P></BODY></HTML> Wed, 26 Jul 2017 07:09:24 GMT Kushal_Chawda 2017-07-26T07:09:24Z Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371599#M822907 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Is there any function to convert date&amp; time value to epoch format ? </P><P></P><P> below is the sample </P><P><SPAN style="color: #000000; font-family: 'Open Sans', 'Lucida Grande', sans-serif; font-size: 14px;">"Wednesday, July 26, 2017 6:38:00 AM" convert to&nbsp; "<SPAN style="color: #000000; font-family: 'Open Sans', 'Lucida Grande', sans-serif; font-size: 14px;">1501051080" (epoch)</SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371599#M822907 manojkulkarni 2020-11-25T16:16:04Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371600#M822908 <HTML><HEAD></HEAD><BODY><P>I am hearing first time this? What does this <SPAN style="color: #000000; font-family: 'Open Sans', 'Lucida Grande', sans-serif; font-size: 14px;">1501051080 indicates? I mean to say any minutes / Seconds ??</SPAN></P></BODY></HTML> Wed, 26 Jul 2017 06:51:59 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371600#M822908 Anil_Babu_Samineni 2017-07-26T06:51:59Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371601#M822909 <HTML><HEAD></HEAD><BODY><P>try this, make sure that <SPAN style="font-size: 13.3333px;"><STRONG>DateField </STRONG>is in number format</SPAN></P><P></P><P>=Floor((DateField-MakeDate(1970,1,1))*86400)</P></BODY></HTML> Wed, 26 Jul 2017 07:09:24 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371601#M822909 Kushal_Chawda 2017-07-26T07:09:24Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371602#M822910 <HTML><HEAD></HEAD><BODY><P>it is in milliseconds</P></BODY></HTML> Wed, 26 Jul 2017 07:10:43 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371602#M822910 manojkulkarni 2017-07-26T07:10:43Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371603#M822912 <HTML><HEAD></HEAD><BODY><P>Or if it is time(Date field) do multiply <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>86400000</STRONG></SPAN></P></BODY></HTML> Wed, 26 Jul 2017 07:19:21 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371603#M822912 Anil_Babu_Samineni 2017-07-26T07:19:21Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371604#M822916 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>might below thread help you</P><P><A __default_attr="2517" __jive_macro_name="idea" class="jive_macro jive_macro_idea" data-orig-content="Convert Unix Timestamp" href="https://community.qlik.com/" modifiedtitle="true" title="Convert Unix Timestamp"></A></P><P></P><P>Regards</P></BODY></HTML> Wed, 26 Jul 2017 07:27:48 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371604#M822916 PrashantSangle 2017-07-26T07:27:48Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371605#M822918 <HTML><HEAD></HEAD><BODY><P>Thanks Kushal, it is working.</P></BODY></HTML> Wed, 26 Jul 2017 07:29:26 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1371605#M822918 manojkulkarni 2017-07-26T07:29:26Z Re: Date & time convert to Epoch https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1728746#M822919 <P>Using:</P><P>LET vTodayUnix = Floor(((Today()-1)-MakeDate(1970,1,1))*86400);</P><P>works perfectly fine, Thank you !</P> Fri, 17 Jul 2020 09:09:24 GMT https://community.qlik.com/t5/QlikView/Date-time-convert-to-Epoch/m-p/1728746#M822919 thuaume 2020-07-17T09:09:24Z