On Tue, 7 Sep 2004, Lee Denny wrote: > Hello, > > I need to perform a select that compares two dates > > I need to return all records that haven't had date_2 set after a given > number of days since date_1. >
... WHERE date_2 < date_1 + INTERVAL X DAY Where X is the number of days. Assuming this is what you asked, giving more information is always good. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]