topic Re: Makedate in where in QlikView https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424797#M700473 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> If u want the less than 14 hour means..simply u can hard code like it</P><P></P><P>Where</P><P>Hour(DI_Evento)&nbsp;&nbsp; &lt;= 14;</P><P></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 12 Nov 2012 13:07:46 GMT MayilVahanan 2012-11-12T13:07:46Z Makedate in where https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424795#M700471 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I´ve a column with time value and i need load whole records that are before 14:00 pm.</P><P></P><P>I´m using it&nbsp; </P><P></P><P>&nbsp;&nbsp; but isn´t work.</P><P></P><P>Thank you</P><P></P><P>time( DT_EVENTO)&nbsp; &lt;= maketime(14,10,0)</P></BODY></HTML> Mon, 12 Nov 2012 12:37:39 GMT https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424795#M700471 2012-11-12T12:37:39Z Re: Makedate in where https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424796#M700472 <HTML><HEAD></HEAD><BODY><P>let vTime=MakeTime(10,20,30);</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">time( DT_EVENTO)&nbsp; &lt;=$( vTime) or '<STRONG style="color: #737373; background-color: #ffffff; font-family: Arial;">$( vTime)'</STRONG></SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><STRONG style="color: #737373; background-color: #ffffff; font-family: Arial;">hope this helps<BR /></STRONG></SPAN></P></BODY></HTML> Mon, 12 Nov 2012 12:41:33 GMT https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424796#M700472 SunilChauhan 2012-11-12T12:41:33Z Re: Makedate in where https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424797#M700473 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> If u want the less than 14 hour means..simply u can hard code like it</P><P></P><P>Where</P><P>Hour(DI_Evento)&nbsp;&nbsp; &lt;= 14;</P><P></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 12 Nov 2012 13:07:46 GMT https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424797#M700473 MayilVahanan 2012-11-12T13:07:46Z Re: Makedate in where https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424798#M700474 <HTML><HEAD></HEAD><BODY><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></P><P><STRONG></STRONG></P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800080; font-size: 8pt;">time</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #008000; font-size: 8pt;">DT_OCORRENCIA</SPAN><SPAN style="font-size: 8pt;"> ) &lt;=&nbsp; </SPAN><STRONG><EM style="color: #646464; font-size: 8pt;"><STRONG><EM style="color: #646464; font-size: 8pt;">'$(vTime)PM' </EM></STRONG></EM></STRONG></P><P></P><SPAN style="color: #0000ff; font-size: 8pt;"><P></P></SPAN><P><EM style="color: #646464; font-size: 8pt;"></EM></P><P></P><P></P><P></P></BODY></HTML> Mon, 12 Nov 2012 13:09:56 GMT https://community.qlik.com/t5/QlikView/Makedate-in-where/m-p/424798#M700474 2012-11-12T13:09:56Z