I have 2 alternate states to select date. Alternate state Date1 and alternate state Date 2. The first expression selects the data from date 1 which is what I want.
However, the 2nd expression should display all the data Between the dates of Date1 and Date2.
So if Date 1 is 1st Jan 2017 and Date 2 is 1st Dec 2017 and if there are 1st jan 2017, 1st feb 2017 .... 1st dec 2017, 1st jan 2018, 1st feb 2018 etc in the date field, then the second expression should display the data of 1st jan 2017 to 1st dec 2017 and exclude 2018 data.
What expression can i write in second expresion for this to happen?
If I select 1st March 2017 on Date 1, then Table 1 will display only 1st March 2017 amount. If Date 2 is also 1st March 2017, then table 2 will just show 1st March 2017 because between Date 1 and Date 2, it is still 1st March 2017. Basically, Date 2 will always be the latest Date than Date 1.