>I want to replace date "18/08/09" instead of "17/08/09 in my "DOA" field of my table(counseling) from record number 1 to 250.

REPLACE DOA WITH DATE(2009,08,18) ;
  FOR DOA = DATE(2009,08,17) AND BETWEEN(RECNO(),1,250) ;
  IN counseling