'Allways one selected value' on 3 selected values

[sravan_v007]

Hi All,

I have a problem.

I Have a moth feeld and i want to use 'Allways one selected value' on 3 selected values...

i.e

another thing is I have 8 months of data for now, so when ever new month will add, It should select last 3 months only.

i.e   "Jan, Feb, Mar, Apr, May, Jun, Jul, Aug" in this I allways want  "Jun, Jul, Aug"  should selected

and

when ever "Sep" will add it should select "Jul, Aug, Sep".

if it's possible please help...

Thanks in advance..

[tresB]

for your desired action(preferrably,Trigger->OnOpen(doc)) , you can write the string expression something like this:

='('&Month(Max(Date))&'|'&Month(Max(Addmonths(Date,-1)))&'|'&Month(Max(Addmonths(Date,-2)))&')'

where, Date is your Date field

Update: PFA

[sravan_v007]

Thanks Tres...

it worked...

I just modified for my reqirement.......

='(' & DATE#(max(Month)-2,'YYYYMM') & '|'  & DATE#(max(Month)-1,'YYYYMM') & '|' &DATE#(max(Month),'YYYYMM') & ')'