I have a document library on SharePoint Online, which has 35,000 documents in it. One of the metadata columns is a date column, and I'd like to be able to search for documents that fall between two dates.
Ordinarily I'd perhaps use a filter on the column, but this won't work for large document libraries because of the 5,000 document view limit of SharePoint. (i.e. not all the date possibilities are listed when you try to filter that column - only the 5,000 that are 'in view'. Plus the fact that you are presented with a huge list of specific dates that appear in the column, and they aren't in date order! So impossible to use really.).
Is it possible to simply create something that allows you to type in 2 specific dates and then search for anything within these dates?