topic how to get time from date in QlikView https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645669#M236660 <HTML><HEAD></HEAD><BODY><P>Hi ..</P><P> i have date like 01/07/2014 07:05:44.0000 i have to display only time of for date..</P><P>please help me...</P><P>Regards,</P><P>chandini.g</P></BODY></HTML> Thu, 16 Oct 2014 12:16:13 GMT Anonymous 2014-10-16T12:16:13Z how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645669#M236660 <HTML><HEAD></HEAD><BODY><P>Hi ..</P><P> i have date like 01/07/2014 07:05:44.0000 i have to display only time of for date..</P><P>please help me...</P><P>Regards,</P><P>chandini.g</P></BODY></HTML> Thu, 16 Oct 2014 12:16:13 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645669#M236660 Anonymous 2014-10-16T12:16:13Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645670#M236661 <HTML><HEAD></HEAD><BODY><P>Use the function Time() so:</P><P></P><P>Time(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> 01/07/2014 07:05:44.0000) returns <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">07:05:44</SPAN></SPAN></P></BODY></HTML> Thu, 16 Oct 2014 12:20:05 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645670#M236661 alexandros17 2014-10-16T12:20:05Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645671#M236662 <HTML><HEAD></HEAD><BODY><P>= time(<STRONG>frac</STRONG>(date#('01/07/2014 07:05:44.0000', 'DD/MM/YYYY hh:mm:ss.ffff')))</P></BODY></HTML> Thu, 16 Oct 2014 12:20:06 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645671#M236662 maxgro 2014-10-16T12:20:06Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645672#M236663 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>can you use the time-function?</P><P></P><P>Kind regards</P><P>Peter</P></BODY></HTML> Thu, 16 Oct 2014 12:20:32 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645672#M236663 peterwh 2014-10-16T12:20:32Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645673#M236664 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>tIme(time#( 01/07/2014 07:05:44.0000,'hh:mm:ss.ffff'))),'hh:mm:ss.ffff')</P></BODY></HTML> Thu, 16 Oct 2014 12:22:03 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645673#M236664 perumal_41 2014-10-16T12:22:03Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645674#M236665 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P> I used = time(frac(date#('STARTDATETIME', ' hh:mm:ss.ffff'))) but its not working please help me...</P></BODY></HTML> Thu, 16 Oct 2014 12:30:44 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645674#M236665 Anonymous 2014-10-16T12:30:44Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645675#M236666 <HTML><HEAD></HEAD><BODY><P>subfield(date,' ',2)</P></BODY></HTML> Thu, 16 Oct 2014 12:31:53 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645675#M236666 sivarajs 2014-10-16T12:31:53Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645676#M236667 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">You dont need to add quotes around field names<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= time(frac(date#(STARTDATETIME, '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DD/MM/YYYY </SPAN>hh:mm:ss.ffff')))</SPAN></P></BODY></HTML> Thu, 16 Oct 2014 12:38:35 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645676#M236667 anbu1984 2014-10-16T12:38:35Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645677#M236668 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P>&nbsp;&nbsp; Thax for your replay i got it..</P><P>Regards,</P><P>Chandini.G</P></BODY></HTML> Thu, 16 Oct 2014 12:51:23 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645677#M236668 Anonymous 2014-10-16T12:51:23Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645678#M236669 <HTML><HEAD></HEAD><BODY><P>Attachment is missing</P></BODY></HTML> Thu, 16 Oct 2014 12:52:34 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645678#M236669 anbu1984 2014-10-16T12:52:34Z Re: Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645679#M236670 <HTML><HEAD></HEAD><BODY><P>Hi.. <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/anbu1984">anbu1984</A></STRONG>..</P><P>&nbsp; Please find following attachment..</P><P>In menuduration i have to display only sec..</P><P>Please help me..</P><P>Regards,</P><P>Chandini.G</P></BODY></HTML> Thu, 16 Oct 2014 13:23:01 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645679#M236670 Anonymous 2014-10-16T13:23:01Z Re: how to get time from date https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645680#M236671 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>USE this;</P><P></P><P>Date#(Timestamp(Datefield,'HH:MM:SS')</P></BODY></HTML> Thu, 16 Oct 2014 13:42:54 GMT https://community.qlik.com/t5/QlikView/how-to-get-time-from-date/m-p/645680#M236671 2014-10-16T13:42:54Z