Private Sub Command1_Click() '显示上个月。 Combo1.Text = DateSerial(Format(Date, "YYYY"), Format(Date, "MM") - 1, Format(Date, "DD")) End SubPrivate Sub Form_Load() Combo1.Text = Date End Sub
textbox.text=dateadd("m",-1,"2002-2-2")
Dim DtTemp As Date DtTemp = combo1.Text Text2 = Format(DateAdd("M", -1, DtTemp), "yyyy-MM-dd")你自己需要保证COMBO中格式为合法的时间格式
'显示上个月。
Combo1.Text = DateSerial(Format(Date, "YYYY"), Format(Date, "MM") - 1, Format(Date, "DD"))
End SubPrivate Sub Form_Load()
Combo1.Text = Date
End Sub
DtTemp = combo1.Text
Text2 = Format(DateAdd("M", -1, DtTemp), "yyyy-MM-dd")你自己需要保证COMBO中格式为合法的时间格式
textbox.text=dateadd("m",1,"2002-2-2") '后一个月 2002-3-2
Text2.Text = DateAdd("m", 1, "2002-2-2")