Dim y As Integer = Date.Today.YearDim m As Integer = Date.Today.MonthDim dt1 As New Date(y, m, 1)Dim dt2 As New Date(y, m, Date.DaysInMonth(y, m)) '获取本月的最后一天Dim Filter As StringFilter = "<记账日期 >= #" & dt1 & "# And 记账日期 <= #" & dt2 & "#>"
Sheet1(5,11).Value = filter