I have some struggle viewing lists with a Group By.
The list contains documents that belong to a certain event. Therefore, we added a lookup field which points to the date + start time from the events. It also adds the event Title using the Add columns to the following fields option. We created a view that is grouping the documents by this event Start Time. It displays the date only though.
This is working fine, but as soon as we exceed the 30 items limit, the group is cut off. This is normal.
Now here's the problem: when I click the group name, it should show a filtered view with all documents that belong to that date. However, it doesn't show any document at all.
I found that this might have to do with the way SharePoint handles the date format. When I click the filter button, I see that it has filtered on date only. When I tick another date, it does show that date. But this time, it shows a different date format on top of the view! See image below.
Our SharePoint is set up for The Netherlands. Our date format is day-month-year.
What is going wrong? Am I doing something wrong?
Any help is greatly appreciated. Thanks in advance!