Where condition Not working with QVD Load

[#1]

Facing issues,while using where condition in QVD load,

LET vDate = MakeDate(Year(Today()),Month(Today()),1);

Load * z,y,z,EndDate

from  FROM [..\..\Shared QVD\test.qvd] (qvd)

where  EndDate >= $(vDate)

[#2]

I tried that,now I dont get any value for EndDate as well as X...wer am I worng

[maxgro]

where  EndDate >= '$(vDate)';

[#4]

Looks like the number conversion worked for me...Thank You everyone!!!

[jagan]

HI,

For Dates also it will work but you have enclose variable in single quotes like below.

Try like this

LET vDate = MakeDate(Year(Today()),Month(Today()),1);

Load * z,y,z,EndDate

from  FROM [..\..\Shared QVD\test.qvd] (qvd)

where  Date(Floor(EndDate)) >= '$(vDate)';

OR  Instead of using MakeDate() you can directly use Today() like below.

LET vDate = MakeDate(Year(Today()),Month(Today()),1);

Load * z,y,z,EndDate

from  FROM [..\..\Shared QVD\test.qvd] (qvd)

where  Date(Floor(EndDate)) >= Today();

Regards,

Jagan.