# Search DATE between 2 DATE points in data

**URL:** <https://discuss.elastic.co/t/search-date-between-2-date-points-in-data/294265>\
**Category:** Kibana\
**Created:** [January 13, 2022, 11:32am UTC](https://discuss.elastic.co/t/search-date-between-2-date-points-in-data/294265 "2022-01-13T11:32:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dvesters](https://avatars.discourse-cdn.com/v4/letter/d/a88e4f/32.png) [@Dvesters](https://discuss.elastic.co/u/Dvesters)\
**Post date:** [January 13, 2022, 11:32am UTC](https://discuss.elastic.co/t/search-date-between-2-date-points-in-data/294265/1 "2022-01-13T11:32:46Z")

</div>

Hi all,

I have data from an HR system  
I have the following dates available for absenteeism (also for holidays)

```auto
SickLeave_StartDate 01-01-2021
SickLeave_EndDate 03-03-2021

```

So this person is sick from January 1 to March 3. When I now look who was sick in February, this person is not shown. I obviously have this problem not only on a month level but also on week and day.

Is it possible that kibana understands that this is a range so if I look who was sick on January 18 that this person comes back?

---

<div class="post-metadata">

**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\
**Post date:** [January 13, 2022, 1:14pm UTC](https://discuss.elastic.co/t/search-date-between-2-date-points-in-data/294265/2 "2022-01-13T13:14:45Z")

</div>

To solve the problem, a few more details would need to be clarified. What kind of document mapping do you have? what is your query and desired output?

if you have a document per sickleave, is it enough to query (SickLeave\_StartDate less than January 18) AND (SickLeave\_EndDate greater than January 18)?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 10, 2022, 1:15pm UTC](https://discuss.elastic.co/t/search-date-between-2-date-points-in-data/294265/3 "2022-02-10T13:15:27Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.