>Dear Sir,
>
>There is date type Field in Table1 and has data as follows
>
>01-01-2004
>05-01-2005
>04-08-2003
>06-03-2004
>07-10-2004
>09-05-2002
>
>I want to scan such dates that have years except year=2004 and 2005 for exapmle
>04-08-2003
>09-05-2002
>
>Please help
SCAN FOR YEAR(DateField) < 2004
or If you have index by that field:
LOCATE
SCAN WHILE YEAR(DateField) < 2004
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.