What is the type of "last_dep"?

What is the TAG definition for "Last_dep" (I assume it is a TAG from what you've written)?

Has this, or something very similar, worked for you before?. . . my concern is the longish alias and with a underscore too. Just don't know how that is handled.

good luck

Jim Nelson

>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?