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]

In script add ceil(month(date_field)) as month_no and after reload put max(month_no) in document triggers.

[#3]

Thanks for your reply...

is there any way we can do it without modifing in script?

[jagan]

Hi Nani,

Try like this

Settings -> Document Properties -> Triggers -> Document Event Triggers-> On Open -> Add Actions-> Add -> Selection-> Select In Field ->

Field - Year

Search String - =Max(Year)

Again Add -> Selection-> Select In Field ->

Field - Month

Search String - =Max(Month)

Finally give OK -> OK -> OK

Hope this helps you.

Regards,

Jagan.

[#5]

Hi Jagan,

Thanks for responding.

I did the same as u mentioned above, Year is getting selected but not month.

when I tried Max(Month) in a test object its displaying "5" as result instead of May.

my month field contains month names not month numbers. so it is not getting selected.

Thanks,

Nani

[daniel_kusiak]

For me it dosen't work otherwise.

[daniel_kusiak]

Try date(max(ceil(date_field)),'MMM') in document triggers.

See the attached file.

[jagan]

Hi,

Try like this

=Text(Max(Month))

Regarsd,

Jagan.

[#9]

By default it is showing Jan as Month.

But I have to display May.

[#10]

Hi Jagan,

Tried, But no luck result is same 5.