Having problem retrieving the data from ES for the 1st of every month

I can't reproduce this. Read again this: About the Elasticsearch category

And provide a pure elasticsearch script like:

DELETE index
PUT index/type/1
{
  "foo": "bar"
}
GET index/type/_search
{
  "query": {
    "match": {
      "foo": "bar"
    }
  }
}