# Custom date format in elasticsearch

**URL:** <https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218>\
**Category:** Elasticsearch\
**Created:** [June 2, 2022, 11:14am UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218 "2022-06-02T11:14:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pranjal\_Sett](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pranjal_sett/32/98834_2.png) [@Pranjal\_Sett](https://discuss.elastic.co/u/Pranjal_Sett)\
**Post date:** [June 2, 2022, 11:14am UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218/1 "2022-06-02T11:14:32Z")

</div>

Hi,

I am trying to index the data with the data as _May 26 2022 17:41:24_ . I have given the format in my index template as _MMM d Y H:m:s_ . I have been following this link for formatting [http://joda-time.sourceforge.net/api-release/org/joda/time/format/DateTimeFormat.html](http://joda-time.sourceforge.net/api-release/org/joda/time/format/DateTimeFormat.html) .

Parsing for this data is happening fine with this mentioned format. After indexing this data I have been seen in Kibana as below:

After Indexing data:  
"configuration\_date\_time": [  
"2022-01-03T17:41:24.000Z"  
],  
So it is coming as 3rd January but actually it is May 26.  
Actual data: "configuration\_date\_time": "May 26 2022 17:41:24",

How come it is converting this May 26 to 3rd Jan. I am confused. Can anyone please help me on this? Where I am missing?

---

<div class="post-metadata">

**Author:** ![Pranjal\_Sett](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pranjal_sett/32/98834_2.png) [@Pranjal\_Sett](https://discuss.elastic.co/u/Pranjal_Sett)\
**Post date:** [June 3, 2022, 7:37am UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218/2 "2022-06-03T07:37:47Z")

</div>

@roopednra...

Can you please help me on that?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [June 4, 2022, 4:09am UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218/3 "2022-06-04T04:09:51Z")

</div>

```auto
DELETE discuss-time

PUT discuss-time
{
  "mappings": {
    "properties": {
      "time" : {"type": "date",
        "format": ["MMM dd yyyy HH:mm:ss"]
      }
    }
  }
}

POST discuss-time/_doc
{
  "time" : "May 26 2022 17:41:24"
}

GET discuss-time/_search
{
  "fields": [
    "*"
  ]
}

```

result

```auto
{
  "took" : 0,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "discuss-time",
        "_id" : "EQDlLIEBmlXOD4xOxm-x",
        "_score" : 1.0,
        "_source" : {
          "time" : "May 26 2022 17:41:24"
        },
        "fields" : {
          "time" : [
            "May 26 2022 17:41:24" <!---- Correct
          ]
        }
      }
    ]
  }
}

```

---

<div class="post-metadata">

**Author:** ![Pranjal\_Sett](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pranjal_sett/32/98834_2.png) [@Pranjal\_Sett](https://discuss.elastic.co/u/Pranjal_Sett)\
**Post date:** [June 7, 2022, 12:08pm UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218/4 "2022-06-07T12:08:03Z")

</div>

Thanks @stephenb .. It works.. 🙂 .. But I am confused why this( _MMM d Y H:m:s_) format give us a wrong result

---

<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, 2022, 12:08pm UTC](https://discuss.elastic.co/t/custom-date-format-in-elasticsearch/306218/5 "2022-07-05T12:08:57Z")

</div>

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