How to filter a list by appended change date range of a specific column

Question

What is the best solution to create a view having a filter on a column that has multiple change date?

For example I want this to list items that have some modification on previous week

Answer 1

step 1- create a column named [TEMP DATE]

step 2- define a workflow

Note : when we want to track any changes in a SharePoint records , we can start a workflow.

you can define a workflow on changes in all records with SharePoint Designer to make a copy of modification date to [DATE TEMP] (that we create in step 1) for keep and hold modification date if happens (check if change occurred on this column then copy to DATE TEMP)

(and then in step 3 filter by this column base on date you want) : for example 10 days before

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/b5fdde13-9b0a-459f-94bf-68636233bf9e/

http://social.msdn.microsoft.com/Forums/zh/sharepointworkflow/thread/be2ff744-7797-4c8f-befc-c9fd3c133f14

and before define this WF you should define and add Date data type to our custom list.

step 3- create a view : with filtering this Date Column

Answer 2

you can do 3 step with NINTEX component

step 1- define a workflow

Note : with graphic UI (Nintex designer) you can easily make a workflow steps you want

step 2- define parameter in named [TEMP DATE]

step 3- create a view : with filtering this Date Column

Answer 3

you can create a Gantt view and set the start and finish of gants for created date and last modified date

and then when you track over the time in Gantt you see any task that between you filter date