Would it work to keep a timestamp on your table, searching only for specified days? It seems easier to me that way.