Selection month

[#1]

Hello

My problem "is simple" to a list box of months I want to know which have been selected and if within that selection this one in particular.

Ex:

Select January, March, July, September, October, November and December, how I can know if this March, I selected?

I've tried all kinds of functions and it is impossible there is always some event that meets my condition.

Thanks for your help

[awhitfield]

Hi Antonio,

you need a field for 'Year' too!

Andy

[#3]

No need to know if this March within selected or is not.

[awhitfield]

If it's selected, it will show Green!

Andy

[#5]

Yes, I know.

But I want a variable for compare with other.

[Anonymous]

Hi

every month in green color are selected,if you want to be sure you can do  a  test , creating a simple table with fields  you  need,once you confirmed  your  info delete the  table.

Regards

[awhitfield]

Sorry Antonio, but I really don't understanding what you are asking for! Can you expand / clarify your requirements?

Regards

Andy

[#8]

I need something like

Index(text(getfieldselections ( Mes, ', ')),'mar')

[#9 · Accepted solution]

Hi Antonio, try this:

=substringcount(concat(DISTINCT Mes),'mar')

If count =1  March is selected...

I hope you serve!

[#10]

Thanks so much, worked perfectly