March 19, 2020 at 9:54 pm
@Date1 = '20150630'
DATEADD(m,6, @Date1) < DATEADD(m,-12,GETDATE())
Ignore this, i got the answer after validating.
March 19, 2020 at 10:03 pm
With >7000 points, how can you claim to be "new to SQL Server"?
Please attempt your own explanation... then we can check it for you.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 19, 2020 at 10:56 pm
DECLARE @Date1 datetime = '20150630'
SELECT DATEADD(m,6, @Date1)
'2015-12-30 00:00:00.000'
SELECT DATEADD(m,-12,GETDATE())
'2019-03-19 22:54:19.727'
'2015-12-30 00:00:00.000' < '2019-03-19 22:54:19.727' = TRUE
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply