# Date time filter not working in a pivot

**URL:** <https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69>\
**Category:** KReporter\
**Created:** [February 7, 2017, 2:59pm UTC](https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69 "2017-02-07T14:59:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)\
**Post date:** [February 7, 2017, 2:59pm UTC](https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69/1 "2017-02-07T14:59:49Z")

</div>

Hi,

We have a report that uses the pivot plugin. We have one of the date time fields in the Select tab set to allow edit. When we try to make changes to the date time field in the Search/Filter Criteria the report’s data doesn’t update. It continues to show the same data set. We haven’t seen this in other report types, only pivot reports. Could this be looked into please?

Thanks,  
Jonny

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [February 8, 2017, 5:45pm UTC](https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69/2 "2017-02-08T17:45:11Z")

</div>

Hi Jonny, I could not reproduce behaviour on my instance. Could you send me your report configuration (the table row content for the report from kreports table) to my usual e-mail address?  
Thanks,  
Valérie

---

<div class="post-metadata">

**Author:** ![aureh](https://avatars.discourse-cdn.com/v4/letter/a/67e7ee/32.png) [@aureh](https://community.spicecrm.io/u/aureh)\
**Post date:** [April 6, 2017, 1:45am UTC](https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69/3 "2017-04-06T01:45:43Z")

</div>

Hello,  
I have the exact same problem.  
I can change the datetime with the popup, then I click on the cross at the top right of the popup, and nothing happens.  
The report is not updated, there is no javascript run, nothing.

---

<div class="post-metadata">

**Author:** ![Freeak](https://avatars.discourse-cdn.com/v4/letter/f/7993a0/32.png) [@Freeak](https://community.spicecrm.io/u/Freeak)\
**Post date:** [November 28, 2017, 2:55pm UTC](https://community.spicecrm.io/t/date-time-filter-not-working-in-a-pivot/69/4 "2017-11-28T14:55:01Z")

</div>

Hi, go to report, edit, tab select and check that the field Select Clause is AND