topic Re: Unix Date Conversion in QlikView https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848128#M297630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>go through below link</P><P><A href="https://community.qlik.com/message/700732">UNIX DATE to Qlikview DATE</A></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/"></A></P><P></P><P></P><P>Regards</P></BODY></HTML> Tue, 26 May 2015 07:41:19 GMT PrashantSangle 2015-05-26T07:41:19Z Unix Date Conversion https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848127#M297629 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a field where date is having values like 1226034855. I want to convert this data based on EST Timezone. </P><P></P><P>Can you please help me in this date conversion.</P></BODY></HTML> Tue, 26 May 2015 07:34:26 GMT https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848127#M297629 2015-05-26T07:34:26Z Re: Unix Date Conversion https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848128#M297630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>go through below link</P><P><A href="https://community.qlik.com/message/700732">UNIX DATE to Qlikview DATE</A></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/"></A></P><P></P><P></P><P>Regards</P></BODY></HTML> Tue, 26 May 2015 07:41:19 GMT https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848128#M297630 PrashantSangle 2015-05-26T07:41:19Z Re: Unix Date Conversion https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848129#M297631 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Can you try this and see if it return the correct value </P><P></P><P>Timestamp(time/86400+25569)&nbsp; AS DateTime,</P><P>DATE(time/86400+25569) AS Date,</P><P></P><P>The result for <SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;">1226034855</SPAN> will be 2008-11-07 05:14:15</P></BODY></HTML> Tue, 26 May 2015 07:46:58 GMT https://community.qlik.com/t5/QlikView/Unix-Date-Conversion/m-p/848129#M297631 antose 2015-05-26T07:46:58Z