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

i am getting the error "Adding a value to a 'datetime' column caused overflow." when I try and run this statement. DATEADD(dd, - 365, p.LASTMISSEDAPPT) < pl.PLDATE. how can I change DATEADD(dd, - 365, p.LASTMISSEDAPPT) to avoid this.

If p.LASTMISSEDAPPT is a float "representing" a date, then this value is likely
to be too high. If it exceeds 2936549 you will get an out or range error
(or similar error). If it represents a date, you should cast it to a
datetime.

0

running32Author Commented: 2010-09-09

Example of a field is the value of the fields could be 9/7/2010. It still does it when I cast the value as datetime 101. thanks