Show data in VIEW by selecting two dates from other table

[haplc]

Hello everyone. 

I am trying to show data selected by view between two dates. 

I have a table "sheet1" and make a slice "iDetail" using this expression:

AND([Time] > DATE("10/04/2023"), [Time] < DATE("10/08/2023")) - where Time is a data variable in the table. 

THen I created a view "filter" and use two column "startdate " and "enddate" in an additional table "ReportIDetail". 

Then I created a view" iDetail" and used these two columns from the table "iReport".

Idea is that user should select data in VIEW "iRepor" and then the slice "iDetail" should filter data using start and end data. 

I tried this expression:

AND([Time] > date(ReportIdetails[Startdate]), [Time] < date(ReportIdetails[End date]))

I am getting data from the Slice but it is not filtered. 

Would be great if you can please tell me how to manage this? 

Thanks and best regards

[AleksiAlkio]

If the "ReportIDetails" table contains just one row and the "Time" is a date column, then you should be able to use.. 
AND([Time] > ANY(ReportIdetails[Startdate]), [Time] < ANY(ReportIdetails[End date]))

[haplc]

Many thanks Aleks.

I am able to get data between two selected dates.

However, issue I am facing is that , like you pointed out, I have to delete all the row before the app is generating the data. How can generate data between two dates without deleting the row in the table? 

I am deleting the rows in Google sheet

Thanks

[AleksiAlkio]

If you have two tables, the quick editable Edit view where you have those two columns start and end dates, one example is that you have one row for each user filtered with the security filter. Then you can have multiple rows in that table. Could that solve your challenge?

[haplc]

Thanks but I am sorry for my ignorance; could you please tell me how to set
security filters?


Kind regards /

[AleksiAlkio]

https://support.google.com/appsheet/answer/10104977?hl=en&ref_topic=10104784&sjid=549106333774706847...

[haplc]

Thanks but I am sorry for my ignorance; could you please tell me how to set security filters?