# How to add default @timestamp to my elastic search data

**URL:** <https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840>\
**Category:** Elasticsearch\
**Created:** [December 21, 2018, 11:56am UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840 "2018-12-21T11:56:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\
**Post date:** [December 21, 2018, 11:56am UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/1 "2018-12-21T11:56:05Z")

</div>

I am trying to populate dashboard in kibana with Elasticsearch data on date fields . I have log file with dates and i find that i don't have `@timestamp` in it.

Here is mapping :

PUT test2  
{  
"settings": {  
"index.mapping.ignore\_malformed": true  
},  
"mappings": {  
"my\_type": {  
"properties": {  
"Size": {"type": "integer","ignore\_malformed": true },  
"Copy Size": {"type": "integer","ignore\_malformed": true }  
"Email Sent Time": {"type": "date"},  
"Creation Time": {"type": "date"},  
"Modification Time": {"type": "date"}  
}  
}  
}  
}

How to add default timestamp? To create area chart in kibana.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 21, 2018, 12:24pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/2 "2018-12-21T12:24:08Z")

</div>

There is no such mechanism in elasticsearch that adds automatically a `@timestamp` field. Best thing to do is to generate it from your application which creates the other fields.

Note that this is not needed by Kibana. If you wish to use a time field you can always tell Kibana to use your `Creation Time` field or one of the other date fields.

---

<div class="post-metadata">

**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\
**Post date:** [December 21, 2018, 12:56pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/3 "2018-12-21T12:56:49Z")

</div>

Thanks David,

I have doubt, when i apply time filter in kibana it's shows no results and without time filter its showing results .  
Now the problem is when i am trying to populate area chart its not working properly .

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/7/37f643ba677a2562d86bfccd150bcc2af6971a57.png)

I don't understand why and what's happening.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 21, 2018, 1:13pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/4 "2018-12-21T13:13:03Z")

</div>

I can't tell with few details but it's better to ask in #kibana channel I think.

---

<div class="post-metadata">

**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\
**Post date:** [December 21, 2018, 1:15pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/5 "2018-12-21T13:15:01Z")

</div>

#kibana channel not replying.

how to check date in elasticsearch , do we have any query to get dates monthly.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 21, 2018, 1:39pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/6 "2018-12-21T13:39:56Z")

</div>

Please keep the discussion in [Date fields are not working](https://discuss.elastic.co/t/date-fields-are-not-working/161497/10) then.

You can always ask again on the same message ( [Date fields are not working](https://discuss.elastic.co/t/date-fields-are-not-working/161497/10) ) to see if someone can help.

---

<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:** [January 18, 2019, 1:39pm UTC](https://discuss.elastic.co/t/how-to-add-default-timestamp-to-my-elastic-search-data/161840/7 "2019-01-18T13:39:56Z")

</div>

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