I've got a large list (85-100k items) in SP2013 that the user wants to filter by month and year (each month of data is 2,500-4,000K items), preferably selecting from drop downs. (Clarification: Users will filter by year month routinely. It needs to perform reasonably, so it needs to be based off of indexed columns)
Trouble is, the date they want to sort by is a basic datetime value, and I'm not finding anything built-in to create this type of UI. (Select month and year, click "GO", get filtered items)
The existing solutions I see for searching by month involve computed columns, however large lists can only filter on indexed columns, and computed columns are not supported for indexing.
How can I accomplish this? (NOTE: I realize I'll probably have to do some custom coding, and that's fine. I want to find a reasonably simple solution involving the least custom coding.)