Mysql Date Format

[Charliezak]

Hi, im trying to get a date range Between anydate to anydate,

my date format is dd.mm.yyyy


this is the table

CREATE TABLE table (
id int(11) unsigned NOT NULL auto_increment,
custid varchar(11) NOT NULL default '',
note text NOT NULL,
date varchar(10) NOT NULL default '',
datefu varchar(10) NOT NULL default '',
PRIMARY KEY (id)
) TYPE = MyISAM;

is it basicly
SELECT * FROM $tablename WHERE datefu BETWEEN DATE $datefa AND DATE $datefb

[Xnuiem]

What is the error you get?

I never use date formats, always use timestamps since they are so much easier to deal with.

[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 ??

[celon_php_master]

use timestamp in the table format