NEED HELP ON T-SQL WHERE CAUSE OF COMPARING TWO DATES: DATE1 AND DATE2

NEED HELP ON T-SQL WHERE CAUSE OF
COMPARING TWO DATES: DATE1 AND DATE2

1) DATE2 > DATE1
      AND
2) DATE2 IS NOT MORE THEN 1 YEAR OF DATE1

EX: IF DATE1 = 02/20/2000
       DATE2 = 02/01/2001
     
     DATE2 IS A VALID DATE

    IF DATE1 = 02/20/2000
       DATE2 = 02/20/2001
   

     DATE2 IS A NOT A VALID DATE
jfreeman2010Asked:
Who is Participating?
 
Rajkumar GsConnect With a Mentor Software EngineerCommented:
Regarding  2) Modify as

DATEDIFF(yy, DATE1, DATE2) <= 1

Raj
0
 
Rajkumar GsSoftware EngineerCommented:
I think, it would be like

1) DATE2 > DATE1

DATEDIFF(d, DATE1, DATE2) > 0

Raj
0
 
Rajkumar GsSoftware EngineerCommented:
2) DATE2 IS NOT MORE THEN 1 YEAR OF DATE1

DATEDIFF(y, DATE1, DATE2) <= 1

I am not able to test as I am not having SQL Server machine now.

If not works, interchange position is DATE1 & DATE2

Raj
0
 
Rajkumar GsSoftware EngineerCommented:
3.  DATE2 IS A NOT A VALID DATE

It may look like

ISDATE(DATE2) = 1

Raj
0
 
jfreeman2010Author Commented:
thanks,
0
All Courses

From novice to tech pro — start learning today.