Ideas, create a view that fetches the data based upon the current date
and use MS Query to fetch from the view instead of from the table.