Bulk Insert doesnt insert data when importing text into a date field
<p>It works when I change the field to be varchar but doesn't insert data when the field type is datetime</p>

<pre><code>DECLARE @SQL NVARCHAR(MAX)
 SET @SQL =N'Bulk Insert tblUsersXTemp 
 from '''+ 
 @filePath + 
 N'''WITH (FIELDTERMINATOR = ''","'', 
 ROWTERMINATOR = ''"\n'')';

 EXEC sp_executesql @SQL
</code></pre>

<p><a href="https://i.stack.imgur.com/XyXEu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XyXEu.png" alt="enter image description here"></a></p>