Loading

need to get 15 years back date from datetime

nitin singh

7y859SQL

I have below 2 dates(yyyymmdd format) with which i have to work with

Date1: 2019-02-01
canceldate= 2004-02-28

Now i have select all the records for whome Dte1-canceldate>=15

i used DATEDIFF(YEAR,canceldate,Date1).

Using this command the above condition is satisfied considering difference in year. But actually canceldate 2004-02-28 <15 year and record with canceldate shud not have been selected.

Please let me know how can i correct the above issue

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Hi,

Please use below condition.
SELECT * FROM TableName
WHERE DATEDIFF(YEAR, CancelDate, GetDate()) >= 15
0
Rajeesh Menoth7y ago
Hi,

I think you can add condition in the query. like the following example.

Try this code :
SELECT DATEDIFF(year, canceldate, Date1) AS DateDiff WHERE canceldate != canceldate
// give condtion for avoid canceldate
0
Suraj Kumar7y ago
Can you provide sample data and expected output.
0