# Date range issue for Posts and New Topics report

**URL:** https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612
**Category:** Bug
**Created:** [April 5, 2018, 12:43am UTC](https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612 "2018-04-05T00:43:08Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![BenLeong](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/benleong/32/60951_2.png) [@BenLeong](https://meta.discourse.org/u/BenLeong)
#### Post date: [April 5, 2018, 12:43am UTC](https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612/1 "2018-04-05T00:43:08Z")

</div>

There seem to be a few differences between the data that’s displayed via the **Graph** and **Table** views for the admin panel reports, and the version available for export via CSV.

This example is from the Table view of `/admin/reports/posts`, which seems to be including the date immediately after the selected range (April 1st, instead of ending on March 31).

 ![10%20am](https://global.discourse-cdn.com/meta/original/3X/d/4/d44503e2fa3fe007836392654e6fb88bc7be2eba.png)

The Graph view of that page shows the same range, also ending with “zero posts” on April 1.

 ![26%20am](https://global.discourse-cdn.com/meta/original/3X/a/4/a4590530a7d2ca34c564fa10f014d593e0d4b3ab.png)

However, the data export for this range doesn’t include the additional date, ending on Mar 31, with a value of zero for that day:  
 ![12%20am](https://global.discourse-cdn.com/meta/original/3X/1/a/1a0ac6a98a12781abe0d169f3c9689ada0cd88d8.png)

It’s also worth noting that the last day in the range (both the “extra” day in the Admin/Reports view, and the actual last day from the CSV export) always seems to show zero posts/topics. Selecting a broader range shows that there actually were posts made on that day, though:

 ![40%20am](https://global.discourse-cdn.com/meta/original/3X/2/6/2696c263fda32c8a96cbee3b4434de24630de802.png)

@neil & @travis - this is the issue we discussed earlier today.

---

<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: [April 5, 2018, 1:05am UTC](https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612/2 "2018-04-05T01:05:26Z")

</div>

@techAPJ can you add this to your list to have a look?

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [April 8, 2018, 11:21am UTC](https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612/3 "2018-04-08T11:21:26Z")

</div>

Fixed via:

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

Thanks for bringing this to our notice @BenLeong. 👍

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [April 8, 2018, 12:12pm UTC](https://meta.discourse.org/t/date-range-issue-for-posts-and-new-topics-report/84612/4 "2018-04-08T12:12:16Z")

</div>