If Abs(DateDiff("s", d1, d2)) < 30 Then MsgBox "ok" End If
End Sub
Private Sub Command2_Click() Dim a As Date, b As Date a = "2009-12-11 12:10:10" b = "2009-12-11 12:10:06" If Val(Format(a - b, "ss")) < 30 Then MsgBox "间隔小于30秒" '分钟用nn,小时用HH End If End Sub
if abs(a-b)<30#/24#/3600# then
简单的datediff问题。有送就接
DateDiff 函数 DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) interval 参数的设定值如下: yyyy 年 q 季 m 月 y 一年的日数 d 日 w 一周的日数 ww 周 h 时 n 分钟 s 秒
Private Sub Command1_Click() Dim dateNow As Date Dim date30 As Date dateNow = Now date30 = DateAdd("s", 30, dateNow) Debug.Print dateNow Debug.Print date30 End Sub
Dim d1 As Date
Dim d2 As Date
d1 = "2008-12-10 08:20:20"
d2 = "2008-12-10 08:20:30"
If Abs(DateDiff("s", d1, d2)) < 30 Then
MsgBox "ok"
End If
End Sub
Dim a As Date, b As Date
a = "2009-12-11 12:10:10"
b = "2009-12-11 12:10:06"
If Val(Format(a - b, "ss")) < 30 Then
MsgBox "间隔小于30秒" '分钟用nn,小时用HH
End If
End Sub
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
interval 参数的设定值如下:
yyyy 年
q 季
m 月
y 一年的日数
d 日
w 一周的日数
ww 周
h 时
n 分钟
s 秒
Dim dateNow As Date
Dim date30 As Date
dateNow = Now
date30 = DateAdd("s", 30, dateNow)
Debug.Print dateNow
Debug.Print date30
End Sub