Hi Sheena,
First, SET CENTURY won't matter if it's a character field. FoxPro doesn't see it as a date and you can't compare a date with a character. FoxPro 2.6 isn't any different from VFP on this.
Using a character field for a date is, in my opinion, bad design. And especially since there are only 6 characters, there is no place for the century.
So you're going to have to try something like:
DELETE FOR DATE != "010100"
You'll also have to find out what date format they used, although I'm pretty sure it is DDMMYY.
>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
Sylvain Demers