Seach for changed files based on date

[peter.zalevski]

Hi
We are using vault 9.0
Is there a way in the UI to search for files based on modified date?
We are wanting to find code/files modified in the last 3 months.
I realise I can do a recursive history from the root but that only gives the top 1000 rows and I need to be able to export the filenames of copy out to excel so I can analyse the data.
If nothing in the UI what query can I use on the db.

Thanks
Peter

[Beth]

You can go to the Vault Tools - Options - History and increase the number of rows it will return. Then, after you receive the results, go to Query - Save Results As. Save them as either comma or tab separated. Then you can have Excel import the comma or tab separated file for further manipulation.