topic Re: Problem with dates in QlikView https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491382#M183621 <HTML><HEAD></HEAD><BODY><P>try with:</P><P></P><P>WHERE date(date) &gt;'$(lastReloadTime)';</P></BODY></HTML> Wed, 14 Aug 2013 03:58:15 GMT tresB 2013-08-14T03:58:15Z Problem with dates https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491381#M183620 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to load data to a table based on my last reload time. But my WHERE statement is not working, so I think the date format comparison isnt working because the script loads all dates. Here is my script:</P><P></P><P>LET lastReloadTime = date(ReloadTime());</P><P></P><P>Table:</P><P>Load </P><P>id,</P><P>id_user,</P><P>type, </P><P>date(date) as date</P><P>WHERE (date(date) &gt; $(lastReloadTime));</P><P>SQL SELECT * FROM ....</P><P></P><P>Thank you,</P><P></P><P>Juan.</P></BODY></HTML> Wed, 14 Aug 2013 02:50:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491381#M183620 2013-08-14T02:50:31Z Re: Problem with dates https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491382#M183621 <HTML><HEAD></HEAD><BODY><P>try with:</P><P></P><P>WHERE date(date) &gt;'$(lastReloadTime)';</P></BODY></HTML> Wed, 14 Aug 2013 03:58:15 GMT https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491382#M183621 tresB 2013-08-14T03:58:15Z Re: Problem with dates https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491383#M183622 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 14 Aug 2013 04:01:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-dates/m-p/491383#M183622 2013-08-14T04:01:50Z