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.

[jagan]

Not sure, generally that function works based on string not date.

[#3]

Yeah Jagan it is fetching the maximum string in associated values.

[gautik92]

you can use inline table

Months:

Mapping LOAD * Inline

[months, monthNo.

JAN, 1

FEB, 2

MAR, 3

APR, 4

MAY, 5

JUn, 6

JUL, 7

AUG, 8

SEP, 9

OCT, 10

NOV, 11

DEC, 12

];

ApplyMap('Months', Month), 1) as transactiondate,

then you can take Max(Month)