Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have two variables in my Include file
LET vNumOfYears = 4;
LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD');
Currently I am taking last 4 years of data, but now I just want to show Current Quarter+ last 4 Quarters of data
I want to remove taht 4 in NumOfYears and add my new condition there (4 quarters before + current quarter )
I need to show that in above variables
Please help to get this
thanks!!
Maybe
LET vStartDate = Date(QuarterStart(AddMonths(Today(), -3 * $(vNumOfYears))), 'YYYY-MM-DD');