正确的:
Tables("tb_product").Filter = "[fx_orderdate] = #“ & date.today & ”#"
关于合成表达式,您可以看看:
http://www.foxtable.com/help/topics/1284.htm