import CSV to MySQL and convert date
===

I know this question has been asked before but for some reason I am having zero luck still. I am trying to import a CSV file and convert the date field to proper mysql format (YYYY-MM-DD). I should note that some of the records in the csv have have an empty value, '', for a date value. Not sure if that means anything. I tried running this but had no luck 

    load data local infile '/Users/Path/To/CSV/file.csv' 
    into table donor fields terminated by ',' 
    lines terminated by '\n' (@date,INSTRUCTIONS)
    set date = STR_TO_DATE(@date_date, '%Y-%m-%d')

I'm getting NULL returned for all of them. Any Ideas?