# SQL query for users who have posted on a date (or date range)

**URL:** <https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [October 11, 2018, 4:00pm UTC](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301 "2018-10-11T16:00:37Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![cjk77](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cjk77/32/151779_2.png) [@cjk77](https://meta.discourse.org/u/cjk77)\
**Post date:** [October 12, 2018, 12:04pm UTC](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301/4 "2018-10-12T12:04:41Z")

</div>

Hmmm … I’m not sure that will do exactly what I’m looking for – say I want to query for users who’ve posted on January 1st, for example. Assuming the user has posted since then, the `last_posted_at` field won’t be helpful in that case.

---

_[View the full topic](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301)._