试试DateDiff
'
Dim sql ,Filter as string
Filter ="" '你的条件
sql = "select 归属门店代号,VIP卡号, MAX(消费日期) As 最后购买日期, DateDiff('d',MAX(消费日期),date()) As 多久没来购买 FROM "
sql+="(rjsytVIP消费信息 LEFT JOIN rjsytVIP基本信息 ON (卡号 = VIP卡号 )) GROUP BY VIP卡号, 归属门店代号 Where " & Filter
DataTables("VIP行为信息_VIP行为信息").Fill(sql,"VIP数据", True)