We have a column in a simple view, that is used to purge documents. The first column is sorted, using the simple function Creation Date.
However, there are some documents that don't display their correct creation date. They seem to be displaying another date, but are in the view by their original create date!
For example, there are a bunch of documents created on 8/2/2007. In the midst of these, one document displays 9/25/2007, but is still in the 8/2/2007 documents. This causes our Purge agent to stop.
We have recreated the view index, changed the data type on the column from General to Date/Time, all with no effect. Anyone else ever see this, and if so, what was the solution?
These documents are all created programmatically from the same server, so the server time is not the issue.