How to display only few months in List box

[naveen341]

Hi Guys

I Have a list Box with month field. which is from Jan to Sep.

But i want to display only Jan to jun which is Jan to max(Month)-3.

How can this be achieved in list box.

Thank you

Naveen.

[vamsee]

Try using a variable

vMaxMonth = Max([Month])-3

=IF(AGGR([Month], [Month])<=$(vMaxMonth), [Month])

[sunny_talwar]

May be try this

If(Month <= Max(TOTAL Month) - 3, Month)

[Anil_Babu_Samineni]

Else, If Month field is a string - Then try this?

If(Num(Month(Date#(Month,'MMM'))) <= Max(TOTAL Num(Month(Date#(Month,'MMM')))) - 3, Month)