puling data from one table to another for given period

puling data from one table to another for given period

I need to be able to look at a table of data  and then grab data covering a 7 day period into another table where it will remain unchanged while main table continually updates every hour.  Basically I want something that I can go in at the end of a week and run a query that returns rows of data that were entered or changed in that last 7 day. period.  Is this possible in Zoho and how do I do it?