# Include boundaries in "is between" filter in advanced search

**URL:** <https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859>\
**Category:** Uncategorized\
**Created:** [May 4, 2023, 7:18am UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859 "2023-05-04T07:18:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chtipec](https://avatars.discourse-cdn.com/v4/letter/c/58f4c7/32.png) [@chtipec](https://forum.manager.io/u/chtipec)\
**Post date:** [May 4, 2023, 7:18am UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859/1 "2023-05-04T07:18:21Z")

</div>

Manager desktop version 23.5.3.816  
Advanced search on sale invoices

It seems there is an inconsistancy with the advanced search: “issue date” “is between”.  
Is it normal that the selected FROM date is included but the TO date selected is exclude.?

just to complete after test, FROM date also seems to be exclude (it means you need to select one day before to have the date needed)

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/d/5d1f0fb361cdf6d893ebf3d8b87a3f0c385b947a.png)  
opération on 2023-04-30 will not appear  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/0/306cd76d3466262f4756bb2467720bd75e3ff145.png)  
opération on 2023-04-01 and 2023-04-30 will appear in selection

Advanced search also return blank result (doesn’t select nothing) when applied from another page than the first page of sale invoice list

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [May 4, 2023, 8:46am UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859/2 "2023-05-04T08:46:33Z")

</div>

There are three options on the Issue Date search  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/3/531f247bfa3e63b27f6e5f2c593419312b722f30.png)  
is between  
is before “date”- only transaction before the date ie transactions on the the date are excluded  
is after “date” - only transaction after the date ie transactions on the the date are excluded

The “is between” is an amalgamation of the “is before” and “is after” and so is not strictly correct to use “is between” which most people would expect would include transactions on the dates selected

Whether this is a bug or not depends on how pedantic you are - I would consider it a bug

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [May 4, 2023, 1:16pm UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859/3 "2023-05-04T13:16:16Z")

</div>

Very good point @Joe91.

I think the expected behavior for between is to include the boundaries.

I’m going to place this in ideas.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [May 4, 2023, 11:41pm UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859/4 "2023-05-04T23:41:21Z")

</div>

I agree. `In between` should be inclusive range. Fixed in the latest version (23.5.5.819)

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [July 5, 2026, 8:06pm UTC](https://forum.manager.io/t/include-boundaries-in-is-between-filter-in-advanced-search/46859/5 "2026-07-05T20:06:24Z")

</div>

Uncategorized topics older than 3 years with no recent activity