Need help with date functionality

First off I apologize for my lack of knowledge, I am quite new. I have been working on this issue for several hours and can’t figure it out. Hopefully, I have explained myself clearly enough, here goes…

I have a data type called “employees” with data fields that include first name, last name etc. One of the fields is “work days” which is a list of dates.

I’d like to create a Repeating group where I can search based on the days worked. Here’s what it looks like.

I would like the RG to show the results based on the date range between the Start time picker and the end time picker. So i can see all the days each employee worked during that time period.

The Repeating Group is currently searching for employees but when I try to make an expression that works with the list of dates It keeps failing. I also created split date range for each day that is based of the time pickers start and end but only works with first item instead of list even though the days worked is a list. I’ve tried many other things with set states and ranges but I can’t find a solution.

Hopefully, someone can help.

Thank you so much for your assistance


Store workdates in seperate table linked to user. RG is of type workmates but then displays linked user in contexts that you want it to do so.

Hi and thank you for the comment and quick response. I tried it out but still having an issue. I added a data type called work days with 2 fields, Employee which references the original data type employees. Then date. This means every day each employee worked it would create a new record. The issue with this was that the RG now searching for work days, would show multiple work records for each day,

As you can see Tristan shows up twice. With many employees and many work days, this is not what I am aiming for. Then I tried making another data field under work days which was a list of dates. This brought me back to my original issue.

Ideally, I am looking for the same RG layout as in the first photo where the days worked displa the list of dates that are within the Start and end date picker. There must be a way to search for a list of dates contained within those dates. I wish it gave me the < and > functions.

Hope someone can help.

Thank you,

keep same architecture and get the employee from the matching data (unique elements) or group by employee and show only one day in details.