I am importing records from Interbase into a SQL Server staging table. I need to take a date field in the staging table that is in the format: "yyyy-mm-dd hh:mm:ss.000" and put it in the final table as SmallDateTime field with format of "yyyy". I tried using "DatePart(yyyy, DateRequested)" but it ends up in the receiving field as "06/29/1905" when the date coming in is "2005-04-12 01:25:12.111". I have studied the documentation but I still don't get it. Thanks for any advice.