# "Great Reply" granted date is actually the date of the post

**URL:** https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802
**Category:** Bug
**Created:** [27 januari 2020 om 03:46 UTC](https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802 "2020-01-27T03:46:19Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![seanblue](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@seanblue](https://meta.discourse.org/u/seanblue)
#### Post date: [27 januari 2020 om 03:46 UTC](https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802/1 "2020-01-27T03:46:19Z")

</div>

On [https://community.wanikani.com/](https://community.wanikani.com/) I got a notification that someone liked my post, following by a “great reply” notification. This like was indeed the 50th like for that post. However, it says I earned the “great reply” badge 5 days ago. I’ve seen this happen at least one time before.

 ![image](https://global.discourse-cdn.com/meta/original/3X/a/e/ae497c11597d001b5a01e48fd1336390340ff7d4.png)

 ![image](https://global.discourse-cdn.com/meta/original/3X/d/3/d350d61aa2aea0ceb0517d46c0347b84b6cba638.png)

I made this post 5 days ago, but I would think the badge “grant date” should be based on… well, when it was granted, which is why I put this under #Contribute > Bug. If this is intended, just let me know.

---

<div class="post-metadata">

### Author: ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)
#### Post date: [27 januari 2020 om 18:51 UTC](https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802/2 "2020-01-27T18:51:40Z")

</div>

The Great Reply badge query is using the post’s `updated_at` column to set when the badge was granted. Liking a post does not reset its `updated_at` value, so granted at will be set to the post’s creation date, or to the last time the post was edited.

We have a few other queries that are triggered when a user acts on a post that set the granted at time in the same way. For badges where the query is run once daily, for example the Famous Link badge, `current_timestamp` is used to set `granted_at`. Could a similar approach be used for queries that are triggered when a user acts on a post?

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [28 januari 2020 om 01:18 UTC](https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802/3 "2020-01-28T01:18:54Z")

</div>

Sure this is a simple enough change. Date will not be fixed historically but going forward it should be a little bit saner.

[https://github.com/discourse/discourse/commit/58d6ee36ee460e2f7f5da0121dcbaa7929b7d7d5](https://github.com/discourse/discourse/commit/58d6ee36ee460e2f7f5da0121dcbaa7929b7d7d5)

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [28 januari 2020 om 01:19 UTC](https://meta.discourse.org/t/great-reply-granted-date-is-actually-the-date-of-the-post/139802/4 "2020-01-28T01:19:01Z")

</div>


