Need leading zero for month number is less than 10

[alex20850]

I need to show month of the Received column in the row view with a leading
zero if the number of the month is less than 10.
Today February 12, 2010 should appear as 2010-02-12.
I created a calculated field with the formula
year([Received]) & "-" & month([Received]) &"-"& day([Received])

However, it shows as 2010-2-12.
I can plug in a zero before the month, but if I do that, I will get
2009-012-12 if I look at something in October, November or December and I do
have those in emails in 2009 in this project.

 

[Sue Mosher [MVP]]

You know you won't be able to sort on a calculated field, right? Is there a
custom form involved? What's your business goal here?