关于数据库方面的问题求大神解答

Question

SELECT MainMan,SUM(TranAllowance) AS TranAllowancesum,

 SUM(BasMainService) AS BasMainServicesum,

 SUM(FastService) AS FastServicesum,

 SUM(DeskService) AS DeskServicesum,

 SUM(McDonService) AS McDonServicesum,

 SUM(ServerService) AS ServerServicesum,

 SUM(NetworkService) AS NetworkServicesum,

 SUM(VulnSystemIntegServices) AS VulnSystemIntegServicessum,LEFT(CONVERT(varchar(100), DisDate, 20),7) AS Time  FROM TestTable 

 WHERE dateadd(dd,-day(getdate())+1,getdate())   AND  dateadd(dd,-day(getdate()),dateadd(m,1,getdate())) GROUP   BY MainMan,LEFT(CONVERT(varchar(100), DisDate, 20),7) 

 在RoadFlow 我需要查询日期范围的内容

我查询的时候会显示查询错误  求大神解答！