Trigger

[smilingjohn]

Hi all ,

in the script i have made date as MonthName(Date)

And after reloading the application wheni go to sheet property and  set the trigger as on activate sheet ...and select the field as

Date and under field =Max(Date)

When i go on that sheet this willnot select the max month ...

If i dont convert the the MOnthaname(Date) and just load it as Date

And i set the Sheet Triiger on activating sheet for Field Date and =Max(Date ) this is working

But i want to convert this date into monthname at the script level and then set the trigger in activatibg for max month ......

How can we achive this ?  

Thanks in Advance

[techvarun]

try

Max(MonthName(Date))

[PunamWagh]

Try this,

max(date(date#(MonthName,'MMM'),'MM'))

[smilingjohn]

Hi Varun this not working when i use ur sugestion

[smilingjohn]

This not working Punam

[tresesco · Accepted solution]

Try:

=MonthName(Max(Date))     

[PunamWagh]

Your MonthName field should be in MMM Format..

To Convert Date into Month use Month Function i.e. month(Date) as MonthName at script level

[its_anandrjs]

Try to create your field like

=Date( MonthName(Date) )

Or

=Date( MonthName(Max(Date)) )