Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This statement gives me current year, but I need previous year. What do I need to change to get it.
Thanks
Date((monthname(Today())-1),'MMM YYYY')
Date((monthname(AddYears(Today(),-1))),'MMM YYYY')
or
Date((monthname(AddMonths(Today(),-12))),'MMM YYYY')
Date((monthname(AddYears(Today(),-1))),'MMM YYYY')
or
Date((monthname(AddMonths(Today(),-12))),'MMM YYYY')
Like below
=Year(Date)-1 OR
=Date(Year(Today())-1, 'YYYY') OR
=Year(Date(Year(Today()))-1 )
Thanks Rajni.....just what I needed.