topic Re: Setting variable returns incorrect results? in App Development

Setting variable returns incorrect results?

Wed, 20 Jul 2016 16:41:10 GMT

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?

sunny_talwar — Wed, 20 Jul 2016 16:53:29 GMT

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

Wed, 20 Jul 2016 16:54:28 GMT

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