Sql Error Help

[sqlhelp]

pls help sql server oka query undi 

 

select p.ID,  g.ID, g.Name

from Person p

join Group g on g.Name = 'Members' 

join Sub s on s.subid = p.LinkID and s.orderID = 3

join Suborder so on so.subid = s.id

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

 

 

I am trying to change a subscription period where startdate is -3 months and  enddate is +2 months from the subscription time  but  error vasthundi 

 

Adding a value to a 'datetime' column caused an overflow.

 

what mistake am i doing ?  pls help. 

[puli_keka]

monna naaku ilanti error e vachindi,  datetime2  use cheyali instead of datetime ani..  so even before saving datetime gaani 0001-01-01 unte 1753-01-01 ki changed

 

aina google lo answer leda.. deeniki theddu veyala :O