Max

[#1]

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

[#2]

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

[#3]

Can you please give a example

[#4]

yeah sure,

Just give a sample app with your requirement so that I can give more accurate example.

[#5]

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).

[#6]

i have done like this

Month(MonthName(Max(Date)))  its working ....

is there any other way also???

[CELAMBARASAN · Accepted solution]

Hi,

     Simply use Month(Max(Date)) no need monthname in it.

Celambarasan