If you tried the above script then you need to remove double "," from your script
As per your script itself you can able to get the year.
Please find the below script(Removed only the ,)
LOAD Date#(Date)as Date,
Year(Date#(Date)) as year,
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);