Hi,
Instead of this:
where convert(varchar(10),C.UpdatedON,120) = CONVERT(VARCHAR(10), GETDATE(),120)
you could do something like this:
WHERE DATEADD(dd, 0, DATEDIFF(dd, 0, C.UpdatedON)) = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
Note: instead of "
=" sign you may want to use "
<=" for less than today including today.
Please let me know if this solved your problem.