Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @plus11Month AS CHAR(8) = CONVERT(CHAR(8), CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, CONVERT(CHAR(8), GETDATE(), 112))+11, 0) AS DATE), 112) --The 11th month from the current month
- DECLARE @plus12Month AS CHAR(8) = CONVERT(CHAR(8), CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, CONVERT(CHAR(8), GETDATE(), 112))+12, 0) AS DATE), 112) --The 12th month from the current month
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement