Okay, that sounds good and all, but how does that help me, since the date is chosen from the javascript "calander" in this format: mm/dd/yyyy
So then, when I'm selecting a date of at least todays value, or less in the database how would I do it, since it's in mm/dd/yyyy? Thanks, Richard ----- Original Message ----- From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 15, 2003 2:47 AM Subject: Re: Getting Records where date is LESS THAN today, AND... > >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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
