Clive was the first round these parts to notice that the beloved Twitter Search (formerly known as search.twitter.com) appears to have been revamped, with certain search options apparently retired, notably the ability to specify a date range when searching. *sad face*
However, for some unfathomable reason (unfathomable, at least, to me), some folk appear to object to having to parse Atom or JSON feeds with their own eyes, instead preferring the assistance of a helpful, friendly and intuitive user interface.
It would be fairly straightforward to knock up an API-powered search form to restore some of the now-absent search options, however being strapped for time, I prefer the quick-and-dirty hack of just using Google Spreadsheets as a stopgap solution.
So, for those wishing to search for tweets within a specific timeframe, without harming their eyes, I give you my Google Spreadsheets based hack (fanfare, please!):
You can make your own editable version of this, by just copying the spreadsheet (via the File > Make a copy… drop-down menu).
The spreadsheet uses the clever, but little-known, ImportFeed function, to import the search results into the document, and the query is driven by the cells at the top of the spreadsheet. A little sprinkling of Apps Script ensures that the parameters are safely encoded for transit across the interwebs.
So, that’s my hack! I’m not expecting it to win any prizes for visual aesthetics, but it more or less does the trick for us!
Any other clever hacks out there for achieving this? Being the geek that I am, I’d love to hear about them in the comments… :)