# Creating a -timestamp field

**URL:** <https://discuss.elastic.co/t/creating-a-timestamp-field/100999>\
**Category:** Kibana\
**Created:** [September 19, 2017, 9:26am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999 "2017-09-19T09:26:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![annette](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@annette](https://discuss.elastic.co/u/annette)\
**Post date:** [September 19, 2017, 9:26am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/1 "2017-09-19T09:26:02Z")

</div>

Hi

I need to display all 'documents' outstanding at a certain time every day (Say 1 pm everyday).

Can anyone please help on how I will be able to work out what the current date time is now.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 19, 2017, 9:33am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/2 "2017-09-19T09:33:37Z")

</div>

Work it out where exactly?

---

<div class="post-metadata">

**Author:** ![annette](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@annette](https://discuss.elastic.co/u/annette)\
**Post date:** [September 19, 2017, 11:36am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/3 "2017-09-19T11:36:06Z")

</div>

I do not know what would be the best, to create a scripted field maybe? Or is there be another way?  
(I am VERY new to Kibana)

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 19, 2017, 9:11pm UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/4 "2017-09-19T21:11:37Z")

</div>

How do you know when a document is outstanding?

---

<div class="post-metadata">

**Author:** ![annette](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@annette](https://discuss.elastic.co/u/annette)\
**Post date:** [September 20, 2017, 5:37am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/5 "2017-09-20T05:37:58Z")

</div>

Doc has a Creation date (2017/09/19 00:00:00) , and a status (Open / Released). - I have to display all the docs where the status hasn't been changed to "Released" by 2017/09/19 13:00:00.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 21, 2017, 2:08am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/6 "2017-09-21T02:08:16Z")

</div>

So you want to show everything with that date and status not equal to Released.

Just create a filter with status not equal to Released and then use the time picker to set the exact time you want.

---

<div class="post-metadata">

**Author:** ![annette](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@annette](https://discuss.elastic.co/u/annette)\
**Post date:** [October 6, 2017, 10:11am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/7 "2017-10-06T10:11:50Z")

</div>

Thanks for your help, this unfortunately does not help me because i am already using the time picker to filter on a specific day.

---

<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:** [November 3, 2017, 10:12am UTC](https://discuss.elastic.co/t/creating-a-timestamp-field/100999/8 "2017-11-03T10:12:05Z")

</div>

Closed on November 3, 2017, 10:12am UTC

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