Need Help on Selecting Month as default selection

[#1]

Hi Team,

Hope all re doing good....!

I need help on selecting the month which has recent data as a default selection while opening the application.

For Ex: i have year filed 2015 and in 2015 i have data till may only.

so when i opened my application by default it has to show may.

my month filed has month names not numbers.

i tried Max(month) in document triggers but its not working.

Please help on this.....

Thanks in advance...

Nani.

[daniel_kusiak]

Please see the attached file once more.

[Chanty4u]

hi

PFA

when ever you want to disply  recent selected

you must chk dat option and save it and close

and  reopen ur application....you will get last selected values

hope this helps you

Thank you

Suresh

[jagan]

Hi,

Can you attach sample file, it would be easier to provide the solution.

Or try this

=Text(Date(Max(Month), 'MMM'))

Regards,

Jagan.

[#5]

Hi Suresh,

That is the case in my requirement.

I have to default month to max month which has the data in our application(not last selected month) in month filter.

in 2015 we have data upto may.

so in my scenario I have to default it to may.

[#6]

Try

MaxString(Month)

[#7]

On Field Value Trigger  try  char(max(month))

[#8]

Hi Ashish,

Thanks for your solution.

It is working fine...

Regards,

Nani

[Chanty4u]

hi

try as

sum({<Row={"=[MaxDate] >= max(total [Months])  <="})

Thank you

Suresh

[jagan]

Hi,

This is not the correct solution

If you have data upto december this will return September not December.  Verify it.  If you attach sample file it would be easier to understand your data.

MaxString(Month)

Regards,

Jagan.

[#11]

Hi Jagan,

I tested with 2014 data where I have data till December and it is working and returned Dec.

Thanks,

Nani