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