>Hello:
>
>I've been given a foxpro2.6 table that someone is trying to query on field called date which is 6 characters. I've never used 2.6
>, I'm using 5 and 6.
>
>When they do a delete for date != {01/01/00}
>it deletes all records with this date , it's not recognizing 00 . Any work around for this? Seems like it's setting to 1900.
>
>If I set century on it still doesn't do the query. Any input would be appreciated.
>THanks.
>
>Sheena

Sheena,

In Foxpro 2.6 century alwys defaults to 1900.
Your When condition date != {01/01/00} is actually date != {01/01/1900}.

You have to specify century explicitly date != {01/01/2000}