Tech Tip For The Day: Date Range Google Searches

If you’re like me, a day rarely passes without using Google but one of the long standing issues I’ve encountered with the search engine is narrowing my search parameters by a date range. Fortunately, I ran across a method to enter a date range into a standard Google search but the only trick is the dates must be expressed as a Julian date. Fortunately, there are a few easy to use date converters out there such as the U.S. Naval Observatory Astronomical Applications Department. Once you have your dates expressed in Julian format, just plug them into the Google search as “daterange:startdate-enddate” and you’re all set. I just used this method to for the custom search feature at Inside The Arts to filter out articles about the Columbus Symphony Orchestra written by resident authors over the past 10 days (the search was entered as “Refine results for Columbus daterange:2454657-2454674“). Here’s the final output.

Speaking of Inside The Arts, the slow-down problem encountered by some IE7 users has been fixed. Unfortunately, the only way to correct the problem was to use a different RSS aggregator and although the updated code now works super fast, I have some CSS styling to finish up over the next week. The good news is that all of the articles will be updated automatically and some users won’t have to wait an unbearable amount of time for the homepage to load.

About Drew McManus

"I hear that every time you show up to work with an orchestra, people get fired." Those were the first words out of an executive's mouth after her board chair introduced us. That executive is now a dear colleague and friend but the day that consulting contract began with her orchestra, she was convinced I was a hatchet-man brought in by the board to clean house.

I understand where the trepidation comes from as a great deal of my consulting and technology provider work for arts organizations involves due diligence, separating fact from fiction, interpreting spin, as well as performance review and oversight. So yes, sometimes that work results in one or two individuals "aggressively embracing career change" but far more often than not, it reinforces and clarifies exactly what works and why.

In short, it doesn't matter if you know where all the bodies are buried if you can't keep your own clients out of the ground, and I'm fortunate enough to say that for more than 15 years, I've done exactly that for groups of all budget size from Qatar to Kathmandu.

For fun, I write a daily blog about the orchestra business, provide a platform for arts insiders to speak their mind, keep track of what people in this business get paid, help write a satirical cartoon about orchestra life, hack the arts, and love a good coffee drink.

Related Posts

Leave a Comment