假设3个变量nDay、nHour、nMin分别是你从表A中读出的天、时、分的数值: dim dtNow as Date,dtAdd as Date dtNow = Now() dtAdd = DateAdd(d,nDay,dtNow) dtAdd = DateAdd(h,nHour,dtAdd) dtAdd = DateAdd(n,nMin,dtAdd)
dim dtAdd as Date,dDay as long ,dHour as long ,dMinute as longRs.Open Select * From A,Connection,adOpenDynamic, adLockOptimistic dDay = Rs.Fields("天") dHour = Rs.Fields("时") dMinute = Rs.Fields("分")dtAdd = DateAdd("d",dDay ,Now()) dtAdd = DateAdd("h",dHour ,dtAdd) dtAdd = DateAdd("n",dMinute ,dtAdd)
dim dtNow as Date,dtAdd as Date
dtNow = Now()
dtAdd = DateAdd(d,nDay,dtNow)
dtAdd = DateAdd(h,nHour,dtAdd)
dtAdd = DateAdd(n,nMin,dtAdd)
dDay = Rs.Fields("天")
dHour = Rs.Fields("时")
dMinute = Rs.Fields("分")dtAdd = DateAdd("d",dDay ,Now())
dtAdd = DateAdd("h",dHour ,dtAdd)
dtAdd = DateAdd("n",dMinute ,dtAdd)