Where clause with qualified fields is not working

[#1]

I am getting the following error:  Error: Field not found - <Date>

QUALIFY *;
  GeoLocColSum:
  LOAD REGION,
     Floor(DATE) as Date,
  "TOTAL_REQUESTS",
  "PASSED_REQUESTS",
  "FAILED_REQUESTS",
  ISMAXDATE
 
  Resident GeoLocColSumTemp Where Date>$(vMaxDate);

It is showing the same error even if I use Where GeoLocColSum.Date>$(vMaxDate);

I think this is because of Qualify.

Your help is appreciated.

[oknotsen]

Based on your preceding load, the "date" field is called "DATE" not "Date", so change the where clause to this:

Where DATE >$(vMaxDate);

[sunny_talwar]

Try not to create duplicate threads

Where clause with qualified fields is not working