I have a problem with dates and repeating groups…
Let me explain: I have a database with data and a day of the week (it’s for childcare) basically in the database I have for example a line: Leo, Tuesday, etc… then a line Tia, Thursday, etc
What I would like is to display in the repeating group all the information of the children who are supposed to be present on the day, for example if it’s Tuesday, display all the children and all the information of the children expected on Tuesday except that in my repeating group when I choose
Type of content (I select my database), Data source (Do a search for my database), I choose (Day of the week) = and there … I have no choice to add for example Current date/time formatted as dddd (to display Tuesday or Thursday in letters etc…)
How do I do it please? I’ve been struggling with this for 4 days!!!
Hey, as i understand it, you attached days to children. And then depending on day you want to list all children and show there info right.
Its very easy, i would do it like this:
Create a option set with days:
Add each day to children.
Now there are two way we can show the children in repeating group. Either choosing the day in a drop-down and then passing that drop down as a constraint in rg.
Or
If the day supposed to be user current day.
What we can do to get a option set day dynamicly, we use a hidden group as variable and make it content type as our options set day …
Then in it source we we list all options set and filter it with current_date’extrate day = display of options set … This will only return the day matching current day and then We choose first item because it will only have one item.
Now we can reference the day in rg search as
Day = group_day
Hope this help, if you still puzzling, ping me i would love to Walk you through, without any charge 
