Can you post your complete LOAD statement and post the error message you get?
In general, correctly interprete your date fields:
Then you should be able to limit the date range in a WHERE clause:
WHERE Active_date <= Today(1);
or create a flag in your master calendar:
If(Date <= Today(1), 1,0) AS ToDateFlag,
It seems that you are putting this WHERE statement in the SQL statement. Which I think is the right thing to do because you will only bring those rows which are needed from the database. But the issue here is that QlikView's syntax won't work in your SQL statement because the execution is sent over to the database. So in order to make this WHERE statement to work, you would need a statement which you would use when you run it outside QlikView (for example in TOAD).