Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting variable returns incorrect results?

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?

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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

Not applicable
Author

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