Yusuf,

<< Hi Tim, is it correct that my use of CAST AS INTEGER results in correct DAY values?  >>

Yes, that is correct.  I missed that in your original post (I'm reading these pretty quickly), so my apologies for confusing things.

Tim Young
Elevate Software
www.elevatesoft.com