How do you guys filter the data between 2 dates that matching the date from another table?
Where are you going to use it? With a SELECT expression?
Sorry I am wrong. It should be the other way. AND(date>=date1,date<date2) condition in slice. date1, date2 can be expression from SELECT/LOOKUP.
Iโve tried but type mismatched though the format on both tables are dateโฆ
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |