access里6位数的数字型字段转化为日期型用什么函数答:SELECT *,CDate(Left(CStr(numtime),4)&'-'&Right(CStr(numtime),2)) as numtime2 ,DateDiff('d', [dtime], [numtime2] ) as diffnum FROM 表1 where DateDiff('d', [dtime], CDate(Left(CStr(numtime),4)&'-'&Right(CStr(numtime),2)) )>=0关键是要把数字的转换成合格...