From: Martijn Tonies Date: December 15 2003 8:47am Subject: Re: Getting Records where date is LESS THAN today, AND... List-Archive: http://lists.mysql.com/mysql/155692 Message-Id: <000c01c3c2e8$19786e30$0e02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit >Is there a BETTER way to do this? Yes, store a DATE instead of seperate day/month/year values. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com