Here is what I ended up with after thinking this through... it makes sense to me now, but I am not certain I wrote it right for my application.

select CAST(right(asofdate,6)...

I fixed the reference to DaysPd to Bucket... that did not work.

I should have said since 06/01/2013... I was keeping my data set small while I hammered this out.

Thank you all for the quick responses!