I have a form that allows the user to choose a date for a variable called Select Date. This form is placed on the top of a dashboard.
I have another form that lists Names down 1st column and days across. The form is on the bottom of the same dashboard.
The result is that, when the user chooses a date in the top form, the bottom form displays all the assignments for that week.
What I need is for the user to be able to click on a name and display all the records for the selected user for the selected week. In a previous question I was given the LINKFILTEREDTOVIEW selection option that showed me how to filter by name but now I am having trouble extending the filter to include the date. This is what I’ve tried but the messages is "Arithmetic expression '(Assignments[Work Date] >= Selection[Select Date]) does not have valid input types. If I change the >= to = the Expression is accepted
LINKTOFILTEREDVIEW(“Assigned Jobs”,AND([Worker]=[_ThisRow].[Worker],Assignments[Work Date]>=Selection[Select Date],Assignments[Work Date]<=Selection[Select Date]+6))
How do I modify the Action to display the desired records?