# Date doesn't seem to work with date\_histogram
**URL:** https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515
**Category:** Elasticsearch
**Created:** [April 25, 2018, 2:45pm UTC](https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515 "2018-04-25T14:45:17Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@himberjack](https://discuss.elastic.co/u/himberjack)
#### Post date: [April 25, 2018, 2:45pm UTC](https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515/1 "2018-04-25T14:45:17Z")
We've made a template that has:
> "properties": {
> "timestamp": {
> "type": "date",
> "format": "epoch\_second"
> },
When reading the \_mapping we get:
> "timestamp": {
> "type": "long"
> }
We are unable to do date\_histogram, as it aggregates by all and not by day as it should be:
> "date\_histogram": {
> "field": "timestamp",
> "interval": "day"
> }
Is the "long" time ok? How can we histogram on this?
---
### Author:  [@polyfractal](https://discuss.elastic.co/u/polyfractal)
#### Post date: [April 27, 2018, 2:03pm UTC](https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515/2 "2018-04-27T14:03:53Z")
It sounds like your template is not being applied correctly, or some data was indexed before the template was put in place. I'd try to get that sorted so that the data is properly mapped as a date. Internally it's just a long, but having correct mapping will make your life a lot easier.
Perhaps the syntax on your template is incorrect, or not matching the right pattern? Can you verify that it was in place before any data was indexed?
---
### Author:  [@himberjack](https://discuss.elastic.co/u/himberjack)
#### Post date: [April 29, 2018, 7:25pm UTC](https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515/3 "2018-04-29T19:25:01Z")
Yes you were right! Thanks!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 27, 2018, 7:25pm UTC](https://discuss.elastic.co/t/date-doesnt-seem-to-work-with-date-histogram/129515/4 "2018-05-27T19:25:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.