I am looking to query the amount of transactions that have posted from September 1 through current date for this year in one query calculation and in another query calculation query the amount of transactions from September 1 through the same date last year. I know how to get the same month last year but I am struggling with the same date last year. Any thoughts?
Thanks
In another Query Calculation - you can use like this
[Your Date Field] between _first_of_month (_add_months (current_date,-12)) AND _add_months (current_date,-12)