Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
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
Hi manish05,
You can use monthname() function or you can pass both year and month. So, max of month is selected from the particular year only.
.
Ashutosh
Can you please give a example
yeah sure,
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???
Hi,
Simply use Month(Max(Date)) no need monthname in it.
Celambarasan