Incremental load issue

[#1]

Hi All,

I am new to qlikview, i am trying to implement incremental load

First i converted my SQL server table into Qvd... i have a field modication time and primary key.

I do want to implement incremental load for inser, update , delete

Can some one help me with error in my script

modification time is in format of 10/22/2012 3:22:45 AM (Please see attached image)

and my script is as follows

Max:

LOAD

Mod_Date

FROM

C:\Monica\Orders.qvd

(qvd);

Res:

Load Mod_Date as ModDate

Resident Max order by Mod_Date Desc;

Let MaxTimeStamp=Peek('ModDate',0);

Let MinDate=Peek('ModDate',-1);

Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'MM/DD/YYYY hh.mm.ss');

drop table Max,Res;

Orders:

SQL SELECT

  "Order_ID",

    "Create_By",

    "Create_Date",

    "Cust_Num",

    "Bill_ID",

     "Mod_By",

    "Mod_Date"

FROM "Comp".dbo."F_Orders"

WHERE Mod_Date >= '$(MaxTIMESTAMP)';  

Concatenate

LOAD

"Order_ID",

    "Create_By",

    "Create_Date",

    "Cust_Num",

    "Bill_ID",

     "Mod_By",

    "Mod_Date"

FROM

C:\Monica\Orders.qvd

(qvd)

where not Exists (Order_ID);

Inner Join

SQL SELECT "Order_ID"

FROM "Comp".dbo."F_Orders";

Store  Orders into ;