This might just be me, but I am having hard time understanding your requirements on date filter and status. You mentioned that your date filter is set to 12/4/2014 but you don't have any records with that date. I am missing something. If the record is closed, will it have a new record in the system (i am assuming for any given criteria) or will the status changed to Closed from Open on the same record.
1) will the status changed to Closed from Open on the same record.-- Yes only status chganes from closed to open
2)our date filter is set to 12/4/2014 but you don't have any records with that date. : I am sorry
I will explain it again suppose if i kept a date filter that is in between 2 dates and status is open it should show me and after say few months the same record has changed from open to close and if keep the date in that region it should still show me, though status is closed because it was open during that period at one point of time(capturing historical data).
Let me know if yoou didnt understand
Based on ur explanation above, you have a date filter and want to show the records if the status change. If thats true, then you are good as the filter is in the date and when the data gets updated it will still work. Let me know if this works.