using a trigger to match a value

[#1]

Hi, I am using a trigger to select the latest month value viz. Jan-12.

Actions - Select in Field

Currently this value is hardcoded in the 'Search String' section.

I tried putting this expression "=month(date(addmonths(today(),-1)))" so that the value changes with every month but it is not working.

The selection trigger doesn't seem to work.

Any suggestions please.

Thank you

[CELAMBARASAN]

Hi,

     It will work If you have month field and the expression should not be enclosed in double qoutes.

     Expression will be =month(addmonths(today(),-1))

Hope it helps

Celambarasan

[vijay_iitkgp]

Hi,

Please do not put expressions in Quote. It will work without quote.

[#4]

Hi Celambarasan,

It still doesn't work.

I have the following values in the table:

Dec-11

Jan-12

Feb-12 etc.

In the search string, if i put Jan-12, selection works but when i use an expression like =month(date(addmonths(today(),-1))) it doesn't work.

BTW, this expression returns only the month name viz. Jan or Dec or Feb.

[vijay_iitkgp]

Hi ,

Use =Month(addmonths(Today(),-1))&'-'&Right(Year(Today(),2))

[#6]

Hi Celambarasan, It still doesn't work.

I have the following values in the table:

Dec-11

Jan-12

Feb-12 etc.

In the search string, if i put Jan-12, selection works but when i use an expression like =month(date(addmonths(today(),-1))) it doesn't work.

BTW, this expression returns only the month name viz. Jan or Dec or Feb.

[CELAMBARASAN]

Hi,

     try with this expression

     =month(addmonths(today(),-1))&'-'&Date(addmonths(today(),-1),'YY')

Hope it helps

Celambarasan

[#8]

Thanks Celambarasan,

I have used the foll. expression. =Date(monthStart(date(addmonths(today(),-1))), 'MMM-YY')

[CELAMBARASAN]

Hi,

     It looks smarter way.

Celambarasan