Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this discussion: Selecting Arbitrary Date Ranges
First of all thanks for the link.
Is it possible to approach this solution through 2 listbox (as i provided in example) ?
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.
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
I can, but I won't. It's the wrong solution.