getting worker exited prematurely after adding this in where clause and createdon >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0) AND createdon < DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0);

[boldpoorav]

Why am I getting worker exited prematurely by adding "createdon >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0) AND createdon < DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0);" in where clause?