select [Assessee Name:], count([Unique Ref]) as 'Total','No of Assessments' as 'Type'
from [Temp Database$A1:AB10000]
where [Skill Category] = 'Total' and month([Date & Time]) = 8 and year([Date & Time]) = 2013
group by [Assessee Name:]
The problem is I want to look at the last months worth of data. At the moment I am using
month([Date & Time]) = 8 and year([Date & Time]) = 2013. This is not good as I would have to go in on the first day of every month and change the month number.
Is there anyway I could add date variables or dates to look back at the last month without me having to change anything?
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst