>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
Jon Rosenbaum
Devcon Drummer