Here's the thing:

Trying to insert record with some apex-ifty code.
Schema says field is date type.
SOQL Dumper spits out 2004-04-05 format
I attempt to insert field_name__c='2004-04-05' in Apex Code
I fail.

Error: Compile Error: Invalid initial expression type for field field_name__c, expecting: Date at line #

Why?

Read Cookbook, Getting started, and forum pages.