日期格式的转换

来源:互联网 发布:windows 下的相对路径 编辑:程序博客网 时间:2024/04/29 10:41
function FormatMyDateTime(myDateTime)
 Dim strYear,strMonth,strDay,strHour,strMinute,strSecond
 Dim sResult
 strYear = "0000" & Year(myDateTime)
 strMonth = "00" & Month(myDateTime)
 strDay = "00" & Day(myDateTime)
 strYear = Right(strYear,4)
 strMonth = Right(strMonth,2)
 strDay = Right(strDay,2)
    sResult = strYear & "-" & strMonth & "-" & strDay
    FormatmyDateTime = sResult
End function