We are trying to create a dashboard filter that uses a date. The operator being used for the date filter is "Is Between". The default for the date should be the first day of the previous year and the first day of this month for the previous year. For example, today is 11/20/2012 so the date filter would default to 1/1/2011 and 11/1/2011. Any ideas on how to do this???
I suspect two SQL statements will work, but I'm not sure how to write the statements. Below is a statement that I tried modifying, but it gives the first day of the month for this year (11/1/2012), I need it to be 11/1/2011. I also need another statement to give 1/1/2011. Any ideas are appreciated.