[Charliezak]

Thanks For the quick reply,

um its not really and error to my understanding MySQL dosnt not like to search ranges by this date format dd.mm.yyyy

i have so far converted dd.mm.yyyy to yyyy-mm-dd

by

SELECT STR_TO_DATE(DATE,'%d/%m/%Y') as Mydate from table1;

But now i want to range it Say SELECT * FROM table1 WHERE Mydate BETWEEN $daterange1 AND $daterange2

so it only select the dates in that range

I have changed it to

 select custid, date, str_to_date(date,'%d.%m.%Y') as datefu from custnotes WHERE datefu BETWEEN DATE '2007-03-01' AND DATE '2007-05-30';

but it says there are 0 entrys

am i doing somthing wrong ??