This format is not supported for insert in SQL Server date field by default. You will need to use CONVERT to do it
INSERT INTO TableName (DateColumn) VALUES (CONVERT(date, '13-02-2014', 105))
105 refers to style. Check this for more details -
CAST and CONVERT (Transact-SQL)[
^]
Hope that helps!