What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.

When I click today I get this:

Showing 2009-06-14 to 2009-06-14 ; current time is 2009-06-14 19:12:14 UTC

When I click yesterday I get this:

Showing 2009-06-13 to 2009-06-14 ; current time is 2009-06-14 19:14:44 UTC

So yesterday shows me June 13th (yesterday) and June 14th (today). This doesn't seem right.

(Ported from Uservoice)

share|improve this question
It seems to have been fixed, with SO revision 4938 introduced minutes ago. This "bug" could then be marked as "completed" – VonC Oct 13 '09 at 6:32

3 Answers 3

I will port here my comment on the UV entry:

True: "yesterday" should be the link allowing me to see what I have done yesterday compared to today.

Instead, I have to:

  • remember the "today" score,
  • go to yesterday
  • and *mentally subtract" it from the "yesterday score".

Very painful ;)

share|improve this answer
Agreed, and it's different from the "last week" link which behaves as expected. – Dav Aug 6 '09 at 22:52
Or you could just edit the URL to use the correct date range... :) – Ether Oct 5 '09 at 5:59

The query for yesterday should be:

where activitytime >= dateadd(day,datediff(day,0,getdate())-1,0)
  and activitytime <  dateadd(day,datediff(day,0,getdate())  ,0)

(using whatever field is appropriate for activitytime)

Edit: Actually, it's just about the link for 'yesterday'. Currently it goes to:


When it should be:


So the simple workaround is just to hack the URL you go to.


share|improve this answer
That seems to be the case since SO revision 4938. Yesterday now means just yesterday! – VonC Oct 13 '09 at 6:34
Yes, it seems fixed now! – Rob Farley Oct 14 '09 at 0:04

I thought I found something but the magic related titles search found this item. But this was first posted in back in June so I'm starting to wonder if this is a feature and not a bug.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .