最近菜鸟实在是多了:^_^ Private Sub Command1_Click() Dim MyDate As Date Dim szOld As String Dim i As Integer szOld = "7-6-05" i = InStrRev(szOld, "-") MyDate = Format(Right(szOld, Len(szOld) - i) & "-" & Left(szOld, i - 1), "yyyy-mm-dd") MsgBox "转换后的日期为:" & MyDate End Sub
Private Sub Command1_Click()
Dim MyDate As Date
Dim szOld As String
Dim i As Integer
szOld = "7-6-05"
i = InStrRev(szOld, "-")
MyDate = Format(Right(szOld, Len(szOld) - i) & "-" & Left(szOld, i - 1), "yyyy-mm-dd")
MsgBox "转换后的日期为:" & MyDate
End Sub