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

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 我需要查询日期范围的内容我查询的时候会显示查询错误  求大神解答！