invalid parameter 1 specified for datadiff
<p>I want to update field everyday automatically in database about duration. the formula is (due date - date now). I want to use sql server agent. But when I test the job its failed.</p>

<pre><code>USE FacilityMonitoring
GO

UPDATE [dbo].[klaim]
   SET selisihint = DATEDIFF ("dd", GETDATE(), durasi_end)
GO
</code></pre>

<p>Query in SQL Server agent:</p>

<p><a href="https://i.stack.imgur.com/KiC9A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KiC9A.png" alt="query in sql server agent"></a></p>

<p>Error:</p>

<p><a href="https://i.stack.imgur.com/UgK7K.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UgK7K.png" alt="error showing like this"></a></p>