Where clause not working on date

[MadiF]

Hi all- I'm trying to limit the load of my data based on date and Qlik is just completely ignoring it- I'm so confused. I've tried all sort of combos of date() and num() etc and nothing works- it keeps ignoring my where clause and loading the full data set. Help? Any ideas? the reducing field is a normal date format (MM/DD/YYYY) and I've tried what I usually use 

'WHERE datefield >= makedate(2016,10,1)' as well as WHERE datefield >= '10/1/2016' to no avail.

If it's an issue with format interpretation I haven't been able to figure out what exactly the problem is. I have a test field in the data itself that basically puts that where clause as an if statement flag field, and the result is as expected- so why won't it work in the load?

[sbarro1]

Hello,

Visually your field looks like a date field, but it's probably interpretated by Qlik like a string. Convert your field and then apply the formatting date : Date(Date#(Field),'MM/DD/YYYY'). After that, your filter will work.

Regards.

[MadiF]

Unfortunately I've tried that and it still doesn't work  😞

[rwunderlich]

Can you post your entire Load statement?

-Rob