# UI post.created\_at date doesn't match DB

**URL:** <https://meta.discourse.org/t/ui-post-created-at-date-doesnt-match-db/150717>\
**Category:** Bug\
**Created:** [7 mei 2020 om 13:18 UTC](https://meta.discourse.org/t/ui-post-created-at-date-doesnt-match-db/150717 "2020-05-07T13:18:21Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Grayden\_Shand](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/grayden_shand/32/166586_2.png) [@Grayden\_Shand](https://meta.discourse.org/u/Grayden_Shand)\
**Post date:** [7 mei 2020 om 13:18 UTC](https://meta.discourse.org/t/ui-post-created-at-date-doesnt-match-db/150717/1 "2020-05-07T13:18:21Z")

</div>

In a user’s activity feed, the date at which a post was made is displayed:  
[![](https://global.discourse-cdn.com/meta/original/3X/9/d/9ddb15553fc11d38dfd2c111cf2c65f8db8c0227.png) ](https://dl.dropboxusercontent.com/s/imioybgfdb2c62c/Screenshot%202020-05-07%2009.12.26.png?dl=0)

However, when I view this post with the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin, I see that it was created on April 21st, not April 20th.

[![](https://global.discourse-cdn.com/meta/original/3X/3/6/362a58f96e37f956a411417fbaafda0616577ca5.png) ](https://dl.dropboxusercontent.com/s/zivs3yx182vzzhw/Screenshot%202020-05-07%2009.14.16.png?dl=0)

So, in the Db the post was created on 4/21, but the UI displays it as being posted on 4/20.

**Why does this matter?**  
We have a custom feature to track visit streaks. Occasionally, people will reach out asking why their streak broke. In this case, it broke because in the Db the user had no activity on 4/20, but from their perspective they see that they posted on that day.

Does anyone know why this would be different in the UI and Db?

---

_[View the full topic](https://meta.discourse.org/t/ui-post-created-at-date-doesnt-match-db/150717)._
