Re: Getting Records where date is LESS THAN today, AND...

2003-12-16 Thread Martijn Tonies
Hi Richard, > 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/ > > 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/?

Re: Getting Records where date is LESS THAN today, AND...

2003-12-15 Thread Richard
yy? 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,

Re: Getting Records where date is LESS THAN today, AND...

2003-12-15 Thread Martijn Tonies
>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 ar

Re: Getting Records where date is LESS THAN today, AND...

2003-12-14 Thread Richard
iginal Message - From: "Richard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 7:54 PM Subject: Getting Records where date is LESS THAN today, AND... I am Creating a newsletter site for my employer, which will allow him to just add the newslet

Getting Records where date is LESS THAN today, AND...

2003-12-14 Thread Richard
I am Creating a newsletter site for my employer, which will allow him to just add the newsletter and choose which day to mail it. a cron job runs everynight and mails out a notice that the newsletter is ready, along with the link. I am having a problem getting the date to match up... I have the