Dim I As Integer For I = 1 To 1000 Debug.Print Format(Date - I, "YYYY-MM-DD") Next
Private Sub command1_click() Dim beginDate As Date Dim EndDate As Date Dim i As IntegerbeginDate = Date EndDate = DateAdd("yyyy", -3, beginDate) MsgBox EndDate For i = 1 To 36 Debug.Print DateAdd("m", -i, beginDate) Next i End Sub'这个例子是从当天开始倒数前三年.
For I = 1 To 1000
Debug.Print Format(Date - I, "YYYY-MM-DD")
Next
Private Sub command1_click()
Dim beginDate As Date
Dim EndDate As Date
Dim i As IntegerbeginDate = Date
EndDate = DateAdd("yyyy", -3, beginDate)
MsgBox EndDate
For i = 1 To 36
Debug.Print DateAdd("m", -i, beginDate)
Next i
End Sub'这个例子是从当天开始倒数前三年.