# Can't get fields with an empty date to show up in a data table

**URL:** <https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052>\
**Category:** Kibana\
**Created:** [June 15, 2021, 8:17pm UTC](https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052 "2021-06-15T20:17:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dandcp](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dandcp](https://discuss.elastic.co/u/dandcp)\
**Post date:** [June 15, 2021, 8:17pm UTC](https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052/1 "2021-06-15T20:17:40Z")

</div>

I have a data table (and I've done this before) let's say the fields are:

Name  
Quantity  
End of Support Date  
End of Contract Date

There are 30 records in the dataset right now. Of those 30 maybe 15 have the end of support date inserted and 10 have the end of contract date and end of support date.

When I create a data table and put

Name as the term I see all 30 records.

When I insert the end of support date, I only see the 15 records BUT in the past I've been able to show the records that didn't have a date, but the "show missing" is greyed out in the options. So how do I show all of the records even if they don't have a date?

---

<div class="post-metadata">

**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\
**Post date:** [June 17, 2021, 10:44am UTC](https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052/2 "2021-06-17T10:44:03Z")

</div>

Hi

Could you share a screen of the data table configuration, thx!

Best,  
Matthias

---

<div class="post-metadata">

**Author:** ![dandcp](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dandcp](https://discuss.elastic.co/u/dandcp)\
**Post date:** [June 30, 2021, 4:27pm UTC](https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052/4 "2021-06-30T16:27:48Z")

</div>

![Screen Shot 2021-06-30 at 12.27.29 PM](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1cd97e7765ba4ffb5151b88f077eb093203fde51.png)

---

<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:** [July 28, 2021, 4:27pm UTC](https://discuss.elastic.co/t/cant-get-fields-with-an-empty-date-to-show-up-in-a-data-table/276052/5 "2021-07-28T16:27:49Z")

</div>

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