0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

select
  datepart(ww, creationdate) as [week],
  --cast(creationdate as date) as [Date],
  count(*) as [VBA Questions]
from posts
where 
  tags like '%vba>%' 
  and posttypeid=1
  and creationdate >= dateadd(d,-60,getdate())
  and datepart(ww, creationdate) < datepart(ww, getdate())-1
group by --cast(creationdate as date) ,
datepart(ww, creationdate)
order by datepart(ww, creationdate) --cast(creationdate as date)

fork query

edited aug 21 18

created aug 21 18 ashleedawg