I have some code that looks like this.

USE close_merchant2 IN 0 EXCLU
SELECT close_merchant2
DELETE ALL FOR last_dep >= (dStartDate - 60)
GO TOP
DELETE ALL FOR EMPTY(last_dep)
USE IN close_merchant2

As you can see, i do a calculation on the last_dep and dstartdate. For some strange reason I get a differnet last_dep date than the one that comes in the data. For example, the last_dep date ends up being something in June when the file clearly states it as being something in January. This last_dep date entry is never changed. It is used only to calculate what needs to be in teh table. Is this from table corruption? Do I need to reindex the tables involed to make sure they have good stuff in them?