# Is there a way to filter by date and not by date time in Kibana Lens?
**URL:** https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387
**Category:** Kibana
**Created:** [November 17, 2021, 4:30am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387 "2021-11-17T04:30:04Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Arrick](https://discuss.elastic.co/u/Arrick)
#### Post date: [November 17, 2021, 4:30am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/1 "2021-11-17T04:30:04Z")
I've recently tried to use kibana lens and realised that my time filter in control is filtering by date time. Is there a way to make it filter by date instead?
what I plan to obtain is something similar to this:
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [November 22, 2021, 1:05pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/2 "2021-11-22T13:05:57Z")
One option to do this would be to ingest the current date without time in a separate keyword field, then build the filter based on that. I guess it would be possible to work with date ranges as well, but it won't be as comfortable because AFAIK the UI won't help you with this
---
### Author:  [@Arrick](https://discuss.elastic.co/u/Arrick)
#### Post date: [November 30, 2021, 8:07am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/3 "2021-11-30T08:07:09Z")
From what I know from my research is that I am able to change my date formate by creating a new index pattern data field. However, I am rather confuse on how to move forward. I've read about painless scripting language specifically about datetime formatting too
> [Using Datetime in Painless | Painless Scripting Language [master] | Elastic](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-datetime.html)
Image below is for creating a new index pattern data field called newDate.
Any advice would be appreciated!
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [November 30, 2021, 3:45pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/4 "2021-11-30T15:45:22Z")
Hi @Arrick Welcome to the community.
Did you look at setting a custom time interval in Lens Data Table.
---
### Author:  [@Arrick](https://discuss.elastic.co/u/Arrick)
#### Post date: [December 1, 2021, 5:03am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/5 "2021-12-01T05:03:42Z")
Hello @stephenb , yep I did look at the settings and it does work
However, my issue is more in the control section and not in the lens section. Where I am unable to change my datetime filter into just date (eg, YYYY/MM/DD).
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [December 3, 2021, 9:57pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/6 "2021-12-03T21:57:51Z")
This runtime field -
```auto
ZonedDateTime input = doc['@timestamp'].value;
String output = input.format(DateTimeFormatter.ISO_LOCAL_DATE);
emit(output);
```
Will return date in `yyyy-mm-dd`
This page is very useful for date formatters -
[https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html](https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html)
---
### Author:  [@Arrick](https://discuss.elastic.co/u/Arrick)
#### Post date: [December 5, 2021, 3:52am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/7 "2021-12-05T03:52:31Z")
Hello @ghudgins , thank you for your help! The documentation is really helpful in understanding. I tried to emit my output but kibana just keeps giving me syntax error when emitting. I noticed that I cant emit anything.
I tried changing my type from Date to Long but I still gets the same error when emitting.
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [December 5, 2021, 6:32am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/8 "2021-12-05T06:32:02Z")
The Field Type should be `keyword` since your are emitting a string that you want to aggregate / filter on.
The code above should work.
.
---
### Author:  [@Arrick](https://discuss.elastic.co/u/Arrick)
#### Post date: [December 5, 2021, 7:08am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/9 "2021-12-05T07:08:03Z")
Thank you @stephenb !! It works perfectly now, thank you so much for your guidance
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 2, 2022, 7:08am UTC](https://discuss.elastic.co/t/is-there-a-way-to-filter-by-date-and-not-by-date-time-in-kibana-lens/289387/10 "2022-01-02T07:08:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.