Date Compare

[Anonymous]

I guys, I have this line of code:

Load

               max(Data) as maxDate

Resident Calendar ;

Let vMaxDate = Date($(varMaxDate));

DROP Table Temp;

Table:

LOAD id

     MakeDate(year, month, day) as DateTb,

     effort

FROM

[path ...]

(ooxml, embedded labels, table is xtmp);

TableDate:

LOAD *

Resident Table

where DateTb > $(vMaxDate);

The last part of the script (TableDate) doesn't work, and load all date.

Someone can tell me why the "where" clause doesn't work?

Thanks

[trdandamudi]

May be the where condition is as below:

where DateTb > $('vMaxDate');   <-- see the single quote within the bracket

[Anonymous]

where DateTb > $('vMaxDate');

Are the fields in the same format??

[sunny_talwar]

How do you define varMaxDate?

[Anonymous]

Hi guys, I resolved in this way:

Where Date(DateTb) > '$(vMaxDate)';