topic Re: Incremental load, with seperate lastdate and lasttime fields in QlikView https://community.qlik.com/t5/QlikView/Incremental-load-with-seperate-lastdate-and-lasttime-fields/m-p/738894#M669725 <HTML><HEAD></HEAD><BODY><P>Please...any ideas?</P></BODY></HTML> Thu, 16 Oct 2014 18:49:47 GMT 2014-10-16T18:49:47Z Incremental load, with seperate lastdate and lasttime fields https://community.qlik.com/t5/QlikView/Incremental-load-with-seperate-lastdate-and-lasttime-fields/m-p/738893#M669724 <HTML><HEAD></HEAD><BODY><P>Howdy, i'm having trouble building my incremental data load because my "last modification field" is actually a seperate date and time field..</P><P></P><P></P><P>LASTTIME,</P><P>LASTDATE</P><P></P><P>How do i go about handling this? It's not letting me do..</P><P></P><P>Where TIMESTAMP(LASTDATE,LASTTIME) &gt;= #$(LastExecTime)#</P><P>and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TIMESTAMP(LASTDATE,LASTTIME) &lt; #$(ThisExecTime)#;</P></BODY></HTML> Thu, 16 Oct 2014 13:11:25 GMT https://community.qlik.com/t5/QlikView/Incremental-load-with-seperate-lastdate-and-lasttime-fields/m-p/738893#M669724 2014-10-16T13:11:25Z Re: Incremental load, with seperate lastdate and lasttime fields https://community.qlik.com/t5/QlikView/Incremental-load-with-seperate-lastdate-and-lasttime-fields/m-p/738894#M669725 <HTML><HEAD></HEAD><BODY><P>Please...any ideas?</P></BODY></HTML> Thu, 16 Oct 2014 18:49:47 GMT https://community.qlik.com/t5/QlikView/Incremental-load-with-seperate-lastdate-and-lasttime-fields/m-p/738894#M669725 2014-10-16T18:49:47Z