Hi
How the below Syntax works
cast(DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) as date)
Sales.refdate<cast(DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) as date)
Thanks