# Operator "Within the next n full month" not working

**URL:** <https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474>\
**Category:** KReporter\
**Created:** [July 31, 2019, 5:24pm UTC](https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474 "2019-07-31T17:24:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tessupport](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@tessupport](https://community.spicecrm.io/u/tessupport)\
**Post date:** [July 31, 2019, 5:24pm UTC](https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474/1 "2019-07-31T17:24:07Z")

</div>

When we make a report able to be filtered, and the ‘within the next n full month’ operator is selected, any values typed into the from or to dates do not stick. Is this a known bug?

---

<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:** [August 16, 2019, 4:15pm UTC](https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474/2 "2019-08-16T16:15:05Z")

</div>

I can’t reproduce the error.  
Can you post some pictures of your report settings: select, manipulate and present?  
Which KReporter version is it?  
On which CRM in which version?

---

<div class="post-metadata">

**Author:** ![tessupport](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@tessupport](https://community.spicecrm.io/u/tessupport)\
**Post date:** [August 20, 2019, 8:13pm UTC](https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474/3 "2019-08-20T20:13:09Z")

</div>

Select:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/d2eec08112902a7aba880466d20a8af3a1844726.png)

Manipulate:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/f0b542dd9399dfafd8e3a0ef3d33aaf0260259f3.png)

Present:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/758c772ca8ce6be7335c6d4afd12500589dbe2db.png)

Kreporter 4.2  
SuiteCRM 7.8.17

---

<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:** [August 28, 2019, 6:43am UTC](https://community.spicecrm.io/t/operator-within-the-next-n-full-month-not-working/474/4 "2019-08-28T06:43:53Z")

</div>

Selected operator in your report in YTD. Current year until today.  
That’s not within last n full months.  
I see you have a custom SQL function on invoice date.  
Does last n full months work when you remove it?