dim dtNow
dtNow = date()
dim newDate
newDate = year(dtNow) & "-" & right("0" & month(dtNow),2) & "-" & right("0" & day(dtNow),2)
这个自动将2010-4-20 转化为 2010-04-20
dim dtNow
dtNow = date()
dim newDate
newDate = year(dtNow) & "-" & right("0" & month(dtNow),2) & "-" & right("0" & day(dtNow),2)
这个自动将2010-4-20 转化为 2010-04-20