Do you mean the two closest dates or the two dates that bracket the selected date. I.e. should {06/06/2005} return {26/05/2005},{05/06/2005} or {05/06/2005},{31/08/2005}.

IAC, in VFP there's no easy way to get the *nearest* date. You can use Ryan's suggestion to get the *next higher* date and work from there. You could also use:

=SEEK()
IF FOUND
  ? RECNO()
ELSE
  ? RECNO(0)
ENDIF

which avoids messing with 'SET NEAR' and will get an exact match if available, next higher if not (assuming there is an higher otherwise 0).
HTH,
Viv

>Field1 entitled date1, of table1, has following date type data
>
>{25/02/2005}
>{12/04/2005}
>{22/05/2005}
>{28/05/2005}
>{05/06/2005}
>{31/08/2005}
>
>In text1 I enter date {25/05/2005}, This date is not in table.
>Is it possible to findout TWO closet matching dates i.e
>
>{22/05/2005} && closest smaller date
>{28/05/2005} && closest bigger date