Filter slice by date range from another table

[CRS_R_Newell]

Hello.

I am trying to display data in a slice with dates by filtering from another table.

I have a timesheets table with date entry rows and trying to filter from a payroll date range in another table. Both columns are set to date type but I am getting the error:

Not sure why it thinks its a 'List' as its set to date. This expression works when i simply do a date expression filter like > ()TODAY

Thanks

[TeeSee1]

Payroll Date Range[Start Date] gives a list of date values in the entire [Start Date] col.

So you have to limit it to one value.

If the table has only one row, user ANY(Payroll Date Range[Start Date]).

If not, you have to have a constraint condition added.