AX / Dynamics 365 For Finance and Operations blog

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