invalid parameter 1 specified for datadiff

Question

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.

USE FacilityMonitoring
GO

UPDATE [dbo].[klaim]
   SET selisihint = DATEDIFF ("dd", GETDATE(), durasi_end)
GO

Query in SQL Server agent:

Error:

Answer 1

First argument of datediff() is the datepart. It's not a string though, so replacing "dd" with dd should do the job:

USE FacilityMonitoring
GO

UPDATE [dbo].[klaim]
   SET selisihint = DATEDIFF (dd, GETDATE(), durasi_end)
GO