Set analysis on dates

[mosha231]

Hi

I have created two list box of same column i.e SALE_DATE. i have set second list box in alternate state. i want to show sales data which is present between two dates selected from two list boxes. Example

dates in list box 1   Dates in list box 2              

1/1/2017                   1/1/2017

1/2/2017                   1/2/2017

1/3/2017                  1/3/2017

1/4/2017                   1/4/2017

I select 1/1/2017 from list box 1  and  1/3/2017 list box 2

I want to show data which is present between these two dates

can anyone help ? am new to set analysis

Thanks in Advance

[Gysbert_Wassenaar]

See this discussion: Selecting Arbitrary Date Ranges

[mosha231]

First of all thanks for the link.

Is it possible to approach this solution through  2 listbox (as i provided in example) ?

[Gysbert_Wassenaar]

Yes, it's possible with alternate states and field triggers with select in field actions with complex search strings. Use variables instead like the video tutorial does.

[mosha231]

Great.if possible can you guide me for the List box approach..actually according to the requirement can't give manual input in date variables just have to select dates from listbox.

Between i tried methods provided in link but still i have to give manual inputs to run it so can't follow that approach

[Gysbert_Wassenaar]

I can, but I won't. It's the wrong solution.