I have 2 years 2010 and 2011 , 2010 have months from jan to dec and 2011 have months from jan to Nov.
I want the max(Month) of 2011 that is Nov not Dec, when i clear the selection
You can use monthname() function or you can pass both year and month. So, max of month is selected from the particular year only.
Can you please give a example
Just give a sample app with your requirement so that I can give more accurate example.
I don't have any app for it yaar .... i just tried it with few values in excel with columns Sales and Date (m/d/yyyy).
i have done like this
Month(MonthName(Max(Date))) its working ....
is there any other way also???
Simply use Month(Max(Date)) no need monthname in it.
Retrieving data ...