Get the min and max selected value in a listbox and display in an input box

[#1]

Hello,

Please I have two listboxes. One shows months and the other shows dates in that month. When I select a month it filters all dates in the date list box. I want to get the first date and last date in that listbox and display in an input box. I tried using triggers but still do not get what I want. Please help.

[Anonymous]

John,

If you're are not going to use these input boxes for input, it's better to use text boxes.
Next, assuming that only Month selection should affect the result, and not any other selection, the expressions in you text boxes will be:
=min({1<Month=P(Month)>} Date)
=max({1<Month=P(Month)>} Date)

Regards,
Michael

[#3]

Thank you.