Shulou(Shulou.com)06/03 Report--

After looking up a lot of information before, it was written like this:

SendTime = year (sendTime) & right ("00" & month (sendTime), 2) & right ("00" & day (sendTime), 2) & right ("00" & hour (sendTime), 2) & right ("00" & minute (sendTime), 2) & right ("00" & second (sendTime), 2)

But the result of the run is: YYYY- M-DHHMMSS (2012641338), omitting the zero before the month is single digit, and the intended result is 201206041338

Here are the correct results:

Date data is formatted as yyyymmddhhmmss

Function FormatDate (strDate)

FormatDate=year (Cdate (strDate)) & right ("0" & month (Cdate (strDate)), 2) & right ("0" & day (Cdate (strDate)), 2) & right ("0" & hour (Cdate (strDate)), 2) & right ("0" & minute (Cdate (strDate)), 2) & right ("0" & second (Cdate (strDate), 2)

End Function

The result is 201206041338.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.