注册 登录
编程论坛 VB6论坛

时间取数问题

wxwkcl 发布于 2015-11-09 16:31, 384 次点击
哪位朋友能帮忙用VB代码把下面两个时间格式改一下呵?非常感谢
11/9/2015 12:00:00 AM  改成取值20151109
1/19/2015 12:00:00 AM  改成取值20150119
2 回复
#2
HVB62015-11-09 20:11
回复 楼主 wxwkcl
Private Sub Command1_Click()
   y = Year("11/9/2015 12:00:00 AM")
   m = Month("11/9/2015 12:00:00 AM")
   d = Day("11/9/2015 12:00:00 AM")
   If d < 10 And m < 10 Then
     s = y & "0" & m & "0" & d
   ElseIf d < 10 Then
     s = y & m & "0" & d
   ElseIf m < 10 Then
     s = y & "0" & m & "0" & d
    ElseIf m < 10 Then
     s = y & m & d
   End If
   MsgBox s
End Sub
#3
xiangyue05102015-11-09 20:13
Format(Now(), "YYYYMMDD")
1