求助:sql = "select id,供应商名称,账单编号,账单日期,金额,备注,账单状态,锁定日期 from 供应商账单 where 供应商名称 like '%" & .[c4] & "%' AND 账单编号 like '%" & .[d4] & "%' and 账单日期 between '2022-12-01' and '2022-12-31' "
问题:如何用表达式替2022-12-1'及'2022-12-31'
求助:sql = "select id,供应商名称,账单编号,账单日期,金额,备注,账单状态,锁定日期 from 供应商账单 where 供应商名称 like '%" & .[c4] & "%' AND 账单编号 like '%" & .[d4] & "%' and 账单日期 between '2022-12-01' and '2022-12-31' "
问题:如何用表达式替2022-12-1'及'2022-12-31'