Calendar search only finds recent entries, re-indexing Spotlight doesn't help
MacOS 14.1.1 on MBP. After years of normal operation, the Calendar search function will only find the most recent entries. If I duplicate an old prior event, search will find it even though it is old because it was "refreshed".
Signing out of iCloud, deleting all calendar entries, and then signing back in restores normal Calendar search but only for the iCloud events. However most of my calendar entries is not stored in iCloud but local to my computer. Those entries cannot be searched.
In all other apps, Spotlight search works normally, and it will only find recent Calendar entries, not prior entries. Unchecking and re-checking Events and Reminders in Spotlight doesn't help. Re-indexing Spotlight using Spotlight's privacy setting doesn't help.
Searching the same calendar on my iPhone works normally. Searching on my wife's MBP Calendar app, which mirrors all my calendar events, works normally.
I've contacted Apple Support and they are thinking about it. Posting here in case the community has a brilliant solution. Thanks
MacBook Pro 15″, macOS 12.6