Add or remove days to a date
SELECT DATEADD(DAY, -1, GETDATE()) --Remove 1 day to current date
SELECT DATEADD(DAY, 1, GETDATE()) --Add 1 day to current dateSQL SERVER – Add or remove days to a Date
Add or remove days to a date
SELECT DATEADD(DAY, -1, GETDATE()) --Remove 1 day to current date
SELECT DATEADD(DAY, 1, GETDATE()) --Add 1 day to current date
AX / Dynamics 365 For Finance and Operations blog 