What I am trying to do is create a quarter to date and year to date queries only up to the end of the previous month
So if the query was run in May
Previous quarter would only include April and YTD would only include Jan-Apr
if the query was run in June
Previous quarter would only include April and May and YTD would only include Jan-May
I am having zero luck figuring this out