Try something like SELECT formatted_date FROM mytable WHERE formatted_date BETWEEN '04-08-2003' and '07-08-2003';
Or something along those lines, I would get more specific but I do not have specific information to go from. Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Prashant Akerkar [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 4:27 AM To: [EMAIL PROTECTED]; Karam Chand; [EMAIL PROTECTED]; Donald Longan; miguel solorzano; [EMAIL PROTECTED] Subject: Date Query Dear Friends I have a Query regarding Displaying Dates I have two field in my mysql Table for Date_from and Date_To Retrived record was ' 04-08-2003 ' for Date_from and ' 07-08-2003 ' for Date_To after using Date_Format function to change the default format from YYYY-mm-dd to dd-mm-YYYY I want to now display all the Dates between '04-08-2003' and '07-08-2003' i.e 04-08-2003 05-08-2003 06-08-2003 07-08-2003 on my PHP form. Can anybody help me in this regard? Thanking You, Prashant Akerkar -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs 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]