Hey guys, I'm still not able to get any data from the previous quarters.
The current quarter works fine:
Let vCurrentQtr = 'Q' & ceil(month(Today())/3);
But the previous Quarter returns a 0:
Let vPreviousQtr ='Q' & if(Mod(fabs(vCurrentQtr-1),4)=0, 4, Mod(fabs(vCurrentQtr-1),4));
Does anyone know why this is or does anyone have a alternative formula?
what i usually do in this cases i use the quarterstart function in my calendar
to create a field with the first date of the quarter for each date
then using the addmonths function it always works
in your case your variables will be
Let vCurrentQtr = quarterstart(Today());
Let vPreviousQtr =addmonths(quarterstart(Today()),-3);
another advantage of this method , is it works between year no need for if statement