01-05-2012, 08:50 AM
Hi..
i just tried this...
this will return correct values..
here i is 0 to 11
i=1- for last month
i=6 -6 months ago
i just tried this...
Code:
MonthName(( intMonth - i +11 )mod 12 +1)
this will return correct values..
here i is 0 to 11
i=1- for last month
i=6 -6 months ago