Dimension limit Change in Listbox

[vengadeshpalani]

Hi pls help to find the Calculated field expression for this scenario

Table1

Date1
11/01/2016
11/02/2016
11/03/2016
11/04/2016
11/05/2016
11/06/2016

Table2

Date2
11/01/2016
11/02/2016
11/03/2016
11/04/2016
11/05/2016
11/06/2016

i have two date fields when i click date1 fields, it change Date2 field dimension limit  >=min(Date1)

Output

i click 11/03/2016 in Date1 so Date2 list box change to 

Date2
11/03/2016
11/04/2016
11/05/2016
11/06/2016

[vinieme12]

=AGGR(only({1}if(Date2 >= GetFieldSelections(Date1) , Date2)),Date2)

[vinieme12]

to show all dates in case of no selections made use below

=AGGR(only({<Date2>}if(GetSelectedCount(Date1)=0 , Date2 , if(Date2 >= GetFieldSelections(Date1) , Date2))),Date2)

[MK_QSL]

Go to Settings

Document Properties

Triggers

Field Event Triggers

Select Date1

Click OnSelect - Add Action(s)

Add - Select in Field

Field

Date2

Search String

=If(GetSelectedCount(Date1),'(' & Concat({<Date2 = {'>=$(=Max(Date1))'}>}DISTINCT Date2,'|') &')','')

Do the same for OnChange for Date1

Hope this helps.