Excel>Microsoft Query>SQL Server>多个参数

我对SQL Server和Excel/Microsoft Query比较陌生,

我有这样的问题

Select ...[data]...B1.b,B2.b,B3.b From TABLEA 
Inner join (
 SELECT ---[data]...sum(...) as b From TABLEB
 WHERE Date between [startdate] and [enddate]
) as B1
Inner join (
 SELECT ---[data]...sum(...) as b From TABLEB
 WHERE Date between [startdate-1week] and [enddate]
) as B2
Inner join (
 SELECT ---[data]...sum(...) as b From TABLEB
 WHERE Date between [startdate-2weeks] and [enddate]
) as B3
Where Date between [startdate] and [enddate]

当我手动引入日期时,它是有效的,但是我需要它们是“动态的”(从Excel引入),但是当我放入“?”时。(对于参数)在所有日期上,它都会抛出一个错误。

“无效参数号”

:d如何在Excel中实现此功能?

我正在使用SQL Server和Microsoft Query连接数据。