getting error while doing incremental load

[#1]

Hi Guys,

    I am loading the data from sql server,i have a field callled DOJ and the datatype is date ,that means it displays date

as yyyy-mm-dd,..while i am doing incremental load it gives me an error ..the error is operand type clash date is incompatile

with int.my script for incremental load is

IncLoad:

LOAD id,

    name,

    date(Selectdate) as Selectdate;

SQL SELECT *

FROM NORTHWND.dbo.IncTest where Selectdate>=$(vModDate);

LOAD id,

     name,

     Selectdate

FROM

(qvd) where not exists(id);

could anyone suggest me..

[marcus_sommer]

Try the variable with single-quotes: Selectdate>='$(vModDate)'

- Marcus