28,391
社区成员
发帖
与我相关
我的任务
分享
Function getSeq(sStart, sEnd)
On Error Resume Next
If Not( IsDate(sStart) And IsDate(sEnd)) Then
getSeq = Array()
Exit Function
End If
Dim n, t, t1, t2
Dim a()
t1 = CDate(sStart)
t2 = CDate(sEnd)
If t1 > t2 Then
t = t1
t1 = t2
t2 = t
End If
ReDim a(1)
a(0) = t1
t = t1
Do While t <= t2
t = DateAdd("n", 30, t)
If t <= t2 Then
n = UBound(a) + 1
ReDim Preserve a(n+1)
a(n) = t
End If
Loop
getSeq = a
End Function
Dim i, a
a = getSeq("8:30", "12:30")
For i = 0 To UBound(a)
Response.Write a(i)
Next