Jens,
Correcting a little typo:

SELECT MAX(MyDate) FROM Dates WHERE;
 MyDate <= m.ldSearch;
 UNION;
 SELECT MIN(MyDate) FROM Dates WHERE;
 MyDate >= m.ldSearch

Cetin

>Tariq,
>
>Will this do?
>
>

CREATE CURSOR Dates (MyDate D)
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 2, 25))
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 4, 12))
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 5, 22))
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 5, 28))
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 6, 5))
>INSERT INTO Dates (MyDate) VALUES (DATE(2005, 8, 31))
>
>ldSearch = DATE(2005, 5, 25)
>
>SELECT MAX(MyDate) FROM Dates WHERE;
> MyDate <= ldSearch;
> UNION;
> SELECT MIN(MyDate) FROM Dates WHERE;
> MyDate > ldSearch

>
>
>>Dear Professors
>>
>>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
>>
>>Please help