select CONVERT(char(10),[Reg Date1],103) [Reg Date],Regs
    from (
          select cast(SetupDateTime as DATE) [Reg Date1],COUNT(distinct ID) [Regs]
          from dbo.tbl_User
          where cast(SetupDateTime as DATE) 
                between cast((DATEADD (dd,-7,GETDATE())) AS DATE) 
                    and cast((DATEADD (dd,-1,GETDATE())) AS DATE)
          group by cast(SetupDateTime as DATE)
        ) a
    order by a.[Reg Date1]

但我收到这个错误

Msg 243,Level 16,State 1,Line 1
Type DATE is not a defined system type.