Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Adding the following to my script in Sense 2.4
LET vYearPreviousX2 = Year(YearStart(Today())-2); //Returns (2015)
LET vMonthPreviousX2 = Month(MonthStart(Today())-2); // Returns (Jun)
Returns the same results as:
LET vYearPrevious = Year(YearStart(Today())-1); // Returns (2015)
LET vMonthPrevious = Month(MonthStart(Today())-1); // Returns (Jun)
Anything jump out at you?
You are subtracting 1 or 2 days from your YearStart, which will only take you 2015. May be you need theses
LET vYearPreviousX2 = Year(AddYears(Today(), -2)); //Should give you 2014
LET vYearPrevious = Year(AddYears(Today(), -1)); //Should give you 2015
LET vMonthPreviousX2 = Month(AddMonths(Today(), -2)); //Should give you May
LET vMonthPrevious = Month(AddMonths(Today(), -1)); //Should give you Jun
You are subtracting 1 or 2 days from your YearStart, which will only take you 2015. May be you need theses
LET vYearPreviousX2 = Year(AddYears(Today(), -2)); //Should give you 2014
LET vYearPrevious = Year(AddYears(Today(), -1)); //Should give you 2015
LET vMonthPreviousX2 = Month(AddMonths(Today(), -2)); //Should give you May
LET vMonthPrevious = Month(AddMonths(Today(), -1)); //Should give you Jun
Yur result it´s the same because you subtracts 1 and 2 day of yearstart of today.
if you whant substract 1 or 2 year or months use the expression below:
Year(AddYears(Today(),-1)) = substract 1 year of year of today
Year(AddYears(Today(),-2)) = substract 2 year of year of today
Month(AddMonths(Today(),-1)) = substract 1 month of month of today
Month(AddMonths(Today(),-1)) = substract 2 month of month of today