get data between two dates

[akmalsiddique]

Hi. i want to get data between tow dates in mysql. my date format stored in database is mm/dd/yyyy .when i want to get data shows wrong figure.my query is

SELECT DISTINCT tblvendors.VendorName,tblproducts.ProductCode,tblproducts.ProductName, tblproductsdetail.UpdateDate FROM tblvendors INNER JOIN
tbltracksdetail ON tblvendors.VendorID = tbltracksdetail.VendorID INNER JOIN
tbltracks ON tbltracksdetail.TrackID = tbltracks.TrackID INNER JOIN
tblproductstracks ON tbltracks.TrackID = tblproductstracks.TrackID INNER JOIN
tblproducts ON tblproductstracks.ProductID = tblproducts.ProductID INNER JOIN
tblproductsdetail ON tblproducts.ProductID = tblproductsdetail.ProductID
Where tblvendors.IsEnable = 1 And tblproductsdetail.ProductTypeID=1 and tblproductsdetail.UpdateDate between '01/01/2001' AND '03/31/2009'
please help me.

[Weedpacket]

If you're not storing your dates using an appropriate data type, then that's your big mistake.

If you're using an appropriate type, or if you fix it, the other mistake is pretty minor: writing the dates in the query as 'mm/dd/yyyy' instead of in the standard 'yyyy-mm-dd' format.