RE: NEED HELP DELETING RECORDS FROM A DBF

> >
> > Nadeem
> >
> > Like Norm is correctly make backup to prepare from unknow condition.
> > if only 'delete for year(valdate)=1996' then only delete from Jan 1996 until Dec 1996'
> >
> >
> > DELETE FOR between(valdate, year(valdate)>=1996, year(valdate)=...)
> >
> >
> > BR
> >
> > DAVID KURNIAWAN
> >
> > mamamia
>
> Thanks for correction. I think, he wants delete only year 1996. Yes backup is very important before any new task or program running.
>
> Nadeem Shah

Nadem

After i read question from FoxGuy I think he want delete from 1996 until ... or delete from ... until 1996 so after DELETE FOR must use BETWEEN or use YEAR(VALDATE)>=1996 AND YEAR(VALDATE)<... or use YEAR(VALDATE)>... AND YEAR(VALDATE)<=1996


BR

DAVID KURNIAWAN

mamamia