topic Date and time from TimeStamp in QlikView https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374579#M139482 <HTML><HEAD></HEAD><BODY><P>you can truncate the time using function:</P><P></P><P>DayStart()</P></BODY></HTML> Wed, 28 Mar 2012 17:02:38 GMT 2012-03-28T17:02:38Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374577#M139480 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can return only the date from a Time Stamp field.</P><P>Time Stamp return: 1/1/2011 4.44 PM for example! </P><P>It will be great if i can have the time seperated as well.</P><P>Note that I am loading the data from QVD.</P></BODY></HTML> Wed, 28 Mar 2012 16:22:24 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374577#M139480 2012-03-28T16:22:24Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374578#M139481 <HTML><HEAD></HEAD><BODY><P> floor(TimeStamp) will give data</P><P>TimeStamp - Floor(TimeStamp) will give Time</P><P>Both will have to be formatted.</P></BODY></HTML> Wed, 28 Mar 2012 16:51:22 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374578#M139481 m_woolf 2012-03-28T16:51:22Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374579#M139482 <HTML><HEAD></HEAD><BODY><P>you can truncate the time using function:</P><P></P><P>DayStart()</P></BODY></HTML> Wed, 28 Mar 2012 17:02:38 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374579#M139482 2012-03-28T17:02:38Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374580#M139483 <HTML><HEAD></HEAD><BODY><P>An do you know how to format the time..?</P><P>Thxs</P></BODY></HTML> Wed, 28 Mar 2012 18:01:00 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374580#M139483 2012-03-28T18:01:00Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374581#M139484 <HTML><HEAD></HEAD><BODY><P>use the timestamp function</P></BODY></HTML> Wed, 28 Mar 2012 18:02:48 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374581#M139484 m_woolf 2012-03-28T18:02:48Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374582#M139485 <HTML><HEAD></HEAD><BODY><P>Thxs..</P></BODY></HTML> Wed, 28 Mar 2012 18:59:59 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374582#M139485 2012-03-28T18:59:59Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374583#M139486 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am getting wrong nrs on the time ..</P><P>would you please explain how to frmat the time from TimeStamp?</P><P>Thxs</P></BODY></HTML> Thu, 29 Mar 2012 14:43:52 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374583#M139486 2012-03-29T14:43:52Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374584#M139487 <HTML><HEAD></HEAD><BODY><P> What wrong numbers are you getting?</P></BODY></HTML> Thu, 29 Mar 2012 16:29:48 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374584#M139487 m_woolf 2012-03-29T16:29:48Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374585#M139488 <HTML><HEAD></HEAD><BODY><P>Example of time: 0.60395833332586 while I want it to show as hh:MM AM or something simillar</P><P>Thxs</P></BODY></HTML> Thu, 29 Mar 2012 16:31:17 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374585#M139488 2012-03-29T16:31:17Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374586#M139489 <HTML><HEAD></HEAD><BODY><P>For example:</P><P> =timestamp(YourField,'h:mm:ss TT')</P></BODY></HTML> Thu, 29 Mar 2012 16:37:42 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374586#M139489 m_woolf 2012-03-29T16:37:42Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374587#M139490 <HTML><HEAD></HEAD><BODY><P>this great!</P><P>Thxs..Thxs!</P></BODY></HTML> Thu, 29 Mar 2012 16:47:28 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374587#M139490 2012-03-29T16:47:28Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374588#M139491 <HTML><HEAD></HEAD><BODY><P>HI again,</P><P>quick question :</P><P>this return month name</P><P>Month(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h'))) As Month,</P><P>How can I get the month Nr.</P><P>Thxs</P></BODY></HTML> Fri, 30 Mar 2012 20:07:21 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374588#M139491 2012-03-30T20:07:21Z Date and time from TimeStamp https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374589#M139492 <HTML><HEAD></HEAD><BODY><P><STRONG>Num(Month(Date_Field))</STRONG></P></BODY></HTML> Fri, 30 Mar 2012 21:06:51 GMT https://community.qlik.com/t5/QlikView/Date-and-time-from-TimeStamp/m-p/374589#M139492 m_woolf 2012-03-30T21:06:51Z