I am using CR2008
I am connecting to an excel spread sheet
I am using a SQL command as below
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?