do while loop to compare between dates

[middleoffice]

We have a table with data consisting of multiple dates with different data for each date (e.g. cusip). We would like to be able to select the date that is equal to or closest to (without being greater than) our input date. Should we use a "do while" loop? Or is there an SQL statement that would work? Please help!

 

[jebry]

Hi!

Check out the Max function in SQL. I think this works with dates also, though I have never tried it personally. If you combine the Max function in a query that limits the daes to being equal to or less than your target date, you should get back the date you are looking for.

hth
Jeff Bridgham

P.S. Again, this something I haven't tried so it will probably need some tweaking!