Lester, your approach is correct provided the fact that in your case you criteria to define a record as historic is only its timestamp ( be it limited to the current day or any other date time criteria ).
Unfortunately that is not my case: records contain real estate data and they become historic when properties are sold or the bid is withdrawn, a manual criteria which is reflected by a boolean flag in a field (or by moving the record into another table) Aldo Caruso