lnNum = 1 SELECT TOP lnNum MIN(ABS(Mydate - ldSearch)), MyDate; FROM Dates; GROUP BY 2; ORDER BY 1Then it’s easier to select how large a result set one would get.
>SELECT MAX(MyDate) FROM Dates WHERE; > MyDate <= m.ldSearch; > UNION; > SELECT MIN(MyDate) FROM Dates WHERE; > MyDate >= m.ldSearch >Cetin
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>>