>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}
--sb--