>Where shipdt >= dateadd(m,-6,currdate) gives me a date overflow error.

Jim,

I don't know if this is the problem, but..

The Crystal documentation states the DateAdd() returns a DateTime value. You need to convert that result into a Date value by wrapping the DateAdd() inside a CDate() to compare the result to another date.

Laterness,
Jon