Hi, All<BR>I&#039m new here. My question is how to change date format m/d/yy to mm/dd/yyyy. The follow code only give me four digits for the "year", but month and day are still singal digit. I know I can use <BR>If Len(MyMonth) = 1 Then MyMonth = "0" & MyMonth<BR>MyDay = day(vDate)<BR> If Len(MyDay) = 1 Then MyDay = "0" & MyDay