Last year same month variables

[nareshthavidishetty]

Hi,

We are having the below variables

let vMonthstart = date(MonthStart(today()-1),'1YYMMDD'); = 1161001

Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;=1150101

Here we required an variable which will give same month of last year like ,

VLastMonthStart = 1151001

Thanks..

[t_moutault · Accepted solution]

Hi,

Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;

works fine, give me 1151001

[sunny_talwar]

May be you need this YearStart instead of AddYears because AddYears will just add one year to today's date, whereas YearStart will take you to the beginning of the year

=Date(MonthStart(YearStart((Today()-1),-1)),'1YYMMDD')

[sunny_talwar]

My bad, you do need the same month of last year? If that is the case than what you have is already seems to be working (like Thomas mentioned above)