Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;
works fine, give me 1151001
Hi,
Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;
works fine, give me 1151001
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')
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)