In this code I am pulling particular totals for all 12 months off of a table. This is an on going query that pulls monthly. I want to exclude the current month from this query. How can I get it to not include current month but all previous? I know I need to exclude (today) part but I am not sure what to put in its place..
Code:
....> dateserial(year(today),month(today)-12,1)
Comment