This simple script Convert current datetime to Date removing hours, minutes, seconds
SELECT CONVERT(DATE,GETDATE()) -- Convert current datetime to Date removing hours, minutes, secondsSQL SERVER – COnvert Datetime to Date
This simple script Convert current datetime to Date removing hours, minutes, seconds
SELECT CONVERT(DATE,GETDATE()) -- Convert current datetime to Date removing hours, minutes, seconds
AX / Dynamics 365 For Finance and Operations blog 