The reason this post (Tom on 3/1/2013 at 2:41pm) finally cleared it up for me is that I realized that the functions MONTH, DAY, and YEAR were returning numeric values, which would automatically lack any leading zeroes, regardless of the formatting applied to the date they were extracting from.
... View more
