topic date and time in QlikView https://community.qlik.com/t5/QlikView/date-and-time/m-p/322097#M118663 <HTML><HEAD></HEAD><BODY><P> You should be able to add the date and the time to get the timestamp.</P></BODY></HTML> Tue, 31 Jan 2012 20:04:10 GMT m_woolf 2012-01-31T20:04:10Z date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/322096#M118662 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have date in mm/dd/yyyy format and time in hh:mm:ss format and now i want to make this as datetime.... could someone suggest me the solution.... after that i want to calculate days.hours between two dates of same type..... thanks in advance. </P></BODY></HTML> Tue, 31 Jan 2012 19:37:23 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/322096#M118662 2012-01-31T19:37:23Z date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/322097#M118663 <HTML><HEAD></HEAD><BODY><P> You should be able to add the date and the time to get the timestamp.</P></BODY></HTML> Tue, 31 Jan 2012 20:04:10 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/322097#M118663 m_woolf 2012-01-31T20:04:10Z Re: date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/322098#M118664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Elaborating on that, the following will work</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P class="p1"><SPAN class="s1">=</SPAN><SPAN class="s2">Timestamp</SPAN><SPAN class="s1">(</SPAN><SPAN class="s2">Date</SPAN><SPAN class="s1">(</SPAN>'01/01/2012'<SPAN class="s1">) + </SPAN><SPAN class="s2">Time</SPAN><SPAN class="s1">(</SPAN>'14:00:54'<SPAN class="s1">)) </SPAN></P></PRE><P></P><P>I'm using fixed values, that you can change for the name of the date and time values, respectively.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 31 Jan 2012 21:41:52 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/322098#M118664 Miguel_Angel_Baeyens 2012-01-31T21:41:52Z