下面的这个函数比DateValue快一倍多
Function DateValue2(str1 As String) As Date
arr = Split(str1, "-")
DateValue2 = DateSerial(Val(arr(0)), Val(arr(1)), Val(arr(2)))
End Function
Function DateValue2(str1 As String) As Date
arr = Split(str1, "-")
DateValue2 = DateSerial(Val(arr(0)), Val(arr(1)), Val(arr(2)))
End Function
For i = 1 To 8000
p1 = DateDiff("d", DateValue2("200-12-10"), DateValue2("2002-12-10"))
Next i
用0.671秒
For i = 1 To 8000
p1 = DateDiff("d", DateValue("200-12-10"), DateValue("2002-12-10"))
Next i
用1.272秒
For i = 1 To 8000
p1 = DateDiff("d", "200-12-10", "2002-12-10")
Next i
用2.463秒
日期数据是长整数如 19901219
如何转换成 33226 呢 ?