All in all, upon lots of digging, I was able to find 3 records that were causing the problem. Two of the records had a dash, so trying to grab the first six characters of that field would not necessarily work. I put a case statement in place to catch those records. Then the third record had a month value of 00 and day value of 00, so I added that to the case statement to catch those values, too. Hard to find those 3 in over 8,200 records! Thank you, I appreciate everyones' input into how to troubleshoot this.