I have a requirement wherein I have two listboxes, Both containing different Date fields. Field 1(List box 1) has MMM-YYYY format values. While Field 2(List box 2) has Dates in it. The requirement states that when values are selected in field 1, all the values in the second listbox(Field two) which are greater than the Max(Field 1) selection only needs to be shown. I have tried various different method but it dosent work as expected. Your help is appreciated.
I tried extracting the maximum date of the maximum selection using:
and then put an If condition in the second list box where dates greater than this dates are only to be shown.
I also tried putting this into a variable and using the Only() function with set analysis to get those dates.
Tried using getfieldselection(), but that dosent work
I am neither looking for data nor data logic... all I am looking for is a mock up of your problem using mocked up data where we can see the issue and try to propose you a solution. If you are unable to do that, I am sure someone else might be able to offer help.