# Help Indexing Twitter created\_at field

**URL:** <https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904>\
**Category:** Elasticsearch\
**Created:** [November 5, 2015, 6:06pm UTC](https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904 "2015-11-05T18:06:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sparrowdev](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@sparrowdev](https://discuss.elastic.co/u/sparrowdev)\
**Post date:** [November 5, 2015, 6:06pm UTC](https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904/1 "2015-11-05T18:06:48Z")

</div>

I'm trying to index objects coming in from the Twitter Stream api.  
I've defined the index mapping as following, but the date-picker and histogram panels in Kibana are not accepting the created\_at field properly, so I am unable to filter by time.  
Could my index mapping format be incorrect, or is there another issue at large?

This is how the Twitter created\_at field looks like:

```
"created_at": "Wed Nov 04 03:59:55 +0000 2015"

```

And here are my index settings:

```
 {
  "settings": {
    "analysis": {},
    "mapping.ignore_malformed": false
  },
  "mappings": {
    "tweet": {
      "properties": {
        "created_at": {
          "type": "date",
          "format": "EEE MMM dd HH:mm:ss Z yyyy"
        },
        "truncated": {
          "type": "boolean"
        },
        "timestamp_ms": {
          "type": "string"
        },
        "source": {
          "type": "string"
        },
        "retweet_count": {
          "type": "long"
        },
        "retweeted": {
          "type": "boolean"
        },
        "filter_level": {
          "type": "string"
        },
        "is_quote_status": {
          "type": "boolean"
        },
        "entities": {
          "type": "object"
        },
        "id_str": {
          "type": "string"
        },
        "favorite_count": {
          "type": "long"
        },
        "id": {
          "type": "long"
        },
        "text": {
          "type": "string"
        },
        "lang": {
          "type": "string"
        },
        "user": {
          "properties": {
            "utc_offset": {
              "type": "long"
            },
            "friends_count": {
              "type": "long"
            },
            "profile_image_url_https": {
              "type": "string"
            },
            "listed_count": {
              "type": "long"
            },
            "profile_background_image_url": {
              "type": "string"
            },
            "default_profile_image": {
              "type": "boolean"
            },
            "favourites_count": {
              "type": "long"
            },
            "created_at": {
              "type": "string"
            },
            "description": {
              "type": "string"
            },
            "is_translator": {
              "type": "boolean"
            },
            "profile_background_image_url_https": {
              "type": "string"
            },
            "protected": {
              "type": "boolean"
            },
            "screen_name": {
              "type": "string"
            },
            "id_str": {
              "type": "string"
            },
            "profile_link_color": {
              "type": "string"
            },
            "geo_enabled": {
              "type": "boolean"
            },
            "id": {
              "type": "long"
            },
            "profile_background_color": {
              "type": "string"
            },
            "lang": {
              "type": "string"
            },
            "profile_sidebar_border_color": {
              "type": "string"
            },
            "profile_text_color": {
              "type": "string"
            },
            "verified": {
              "type": "boolean"
            },
            "profile_image_url": {
              "type": "string"
            },
            "time_zone": {
              "type": "string"
            },
            "contributors_enabled": {
              "type": "boolean"
            },
            "profile_background_tile": {
              "type": "boolean"
            },
            "statuses_count": {
              "type": "long"
            },
            "default_profile": {
              "type": "boolean"
            },
            "followers_count": {
              "type": "long"
            },
            "profile_use_background_image": {
              "type": "boolean"
            },
            "name": {
              "type": "string"
            },
            "location": {
              "type": "string"
            },
            "profile_sidebar_fill_color": {
              "type": "string"
            }
          }
        },
        "favorited": {
          "type": "boolean"
        }
      }
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![andresmmujica](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@andresmmujica](https://discuss.elastic.co/u/andresmmujica)\
**Post date:** [December 13, 2015, 3:28pm UTC](https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904/2 "2015-12-13T15:28:39Z")

</div>

bump.. having the same issue..

---

<div class="post-metadata">

**Author:** ![mmv](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@mmv](https://discuss.elastic.co/u/mmv)\
**Post date:** [January 31, 2017, 4:51pm UTC](https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904/3 "2017-01-31T16:51:36Z")

</div>

created\_at field is string. Use the timestamp\_ms field instead

---

<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 5, 2017, 10:03pm UTC](https://discuss.elastic.co/t/help-indexing-twitter-created-at-field/33904/4 "2017-07-05T22:03:42Z")

</div>