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…