I should know how to do this, but I'm looking to grab all records from a table that have a date that is greater then or equal to the max date in the table - 2. Maybe I'm just tired and can't think, please help!

I think that this will take a nested query: I'm not at a place where I can try this, and it'll probably be different between different DBSs, but it should be something like this: select * from table where somedate >= (select max(somedate) -2 from table) -check that max() is a valid function and works on dates -check if just saying -2 is the correct way to back up two days But the idea is that the nested query (select max......) returns one value that is used in the comparison in the where clause of the main query.