Earlier today I wanted to analyse the downloads of RubberDuck VBA. Fortunately, the download numbers have been posted in chat, on a fairly regular basis, and in a fairly consistent format, so while I can't use SEDE for chat, I can use chat search. So, http://chat.stackexchange.com/search?q=Rubberduck.Setup.22.214.171.124.exe&Room=14929&page=1&pagesize=50&sort=newest gets me the data I need....
But, the search results use inconsistent date formats, which means that I have to cleanse the data thoroughly, to use it.
If datestamps are today, I just get the time.
If datestamps are yesterday, I get
ystand the time.
If datestamps are before yesterday and in this calendar week, then I get the abbreviated day name and the time.
If datestamps are before this calendar week and in this calendar year, then I get an abbreviated month name and a day of the month, and a time
If datestamps are before this calendar year, I get an abbreviated Month name, a day of the month, and an abbreviated year (with a leading apostrophe) and a time.
I'm in a locale that uses dd/MM/yyyy date formats, so even the date strings that look a bit like dates, aren't handled all that smoothly.
I understand that the "relative dates" are useful in a standard chat context, but I wonder whether a consistent ISO datetime (eg. YYYY-MM-DD HH:MM:SS) might be more useful in chat search results. It would certainly make doing my analysis easier, but it would undoubtedly help others use chat search as a pseudo SEDE for chat.
Maybe the date format is something that can be configured in search results, or user options?
And finally, for those interested, here is the download chart, based on the cleaned data...