Sql Error Help

[arshad]

 

where cast(getdate() as date) between (dateadd(mm,-3,so.StartDate)) and (dateadd(mm,2,so.EndDate) )

 

Tyr cheyi

 

 

 

Use Month instead of mm

 

SELECT * FROM MyTable
WHERE MyDate < DATEADD(month, -2, GETDATE())

[sqlhelp]

are u getting results when u hardcod the date like '11/1/2014' and 1/1/12015?

 

yes resulsts vasthunayi its just dateadd petinapudu error avthundi 

[loveindia]

Use Month instead of mm

 

SELECT * FROM MyTable
WHERE MyDate < DATEADD(month, -2, GETDATE())

 

what is the difference man??? 

[ceelogreen]

select max(so.EndDate),min(endDate)

 

results  veyi  ba

[arshad]

what is the difference man??? 

 

 

Oh... Already try chesda

[loveindia]

i think the issue, start date or end date is out of range for that table after the addition of -2 months... 

[sqlhelp]

check ur table data...first sometimes end date column ni max time ki default ga insertc hestharu so if ur trying to increment that by 2 months overflow vasthundhi.....for this u can filter by adding a condition tow here clause

 

actually u are right end date is set to a default value  

 

em condition ? 

[loveindia]

DECLARE @Date DATETIME
 
SELECT @Date = '01/01/1753'
 
SELECT DATEADD(D, -1, @Date)

This might be the error man... 

[ceelogreen]

what is the default value of EndDate?

[sqlhelp]

select max(so.EndDate),min(endDate)

 

results  veyi  ba

 

startdate 1/1/2015 

enddate 12/31/2015

[sqlhelp]

DECLARE @Date DATETIME
 
SELECT @Date = '01/01/1753'
 
SELECT DATEADD(D, -1, @Date)

This might be the error man... 

 

 

declare add cheymantunava  in my select query ? 

[dotnetrockz]

startdate 1/1/2015 

enddate 12/31/2015

if these are the dates in ur table then the query shouldnot throw that error

[ceelogreen]

startdate 1/1/2015 

enddate 12/31/2015

 

Max(ENDDATE),Min(ENDDATE)

[loveindia]

declare add cheymantunava  in my select query ? 

 

no man... when you ran the max and min on the start and end dates did you get only 2015 year??? 

[ceelogreen]

if these are the dates in ur table then the query shouldnot throw that error

 

right...