Dumb Question of the day (maybe year)

I am using phpMyAdmin to access MySQL for inputting data - built one table - no problems. I am uploading text files using ; as a delimiter. Second table includes a date (configured as date not datetime). I have tried:
2001-21-06;hello; \r\n
20002106;goodby; \r\n
'2001-21-06';hello; \r\n
'20002106';goodby; \r\n

All I get is:
Date           comment
0000-00-00     hello

I have looked at the manual for MySQL and php, googled - this is so simple no one else has a problem, right?

TIA

--
TK
http://www.wejuggle2.com/
Still Having a Ball







..

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
.

Relevant Pages