SQL Select Statement for Empty Data

[#1]

Hey, so I am trying to load data but only the ones with the following two criterias:

1. The enddate needs to be greater then today's date or
2. If enddate is empty then load the data

LOAD uname as Username,
FROM  (ooxml, embedded labels, table is [test])
WHERE not(date(enddate,'MM/YYYY') < date(today(), 'MM/YYYY')) or enddate = "";

I put the following code into qlikview and I get an error saying Field not found - <>. Does anyone know what I am doing wrong in the code?

[disqr_rm]

Try with enddate = ' ' --> Single quotes. And make sure enddate field is in your XLS file.

I think you can rewite the whole WHERE line as:

WHERE enddate GE today() or len(enddate)=0;

If nothing works, just post here a sample XLS file.