# Search docs using month and day in birthday filed using elasticsearch SQL
**URL:** https://discuss.elastic.co/t/search-docs-using-month-and-day-in-birthday-filed-using-elasticsearch-sql/284844
**Category:** Elasticsearch
**Created:** [September 22, 2021, 10:13am UTC](https://discuss.elastic.co/t/search-docs-using-month-and-day-in-birthday-filed-using-elasticsearch-sql/284844 "2021-09-22T10:13:08Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@RAHUL\_PATEL](https://discuss.elastic.co/u/RAHUL_PATEL)
#### Post date: [September 22, 2021, 10:13am UTC](https://discuss.elastic.co/t/search-docs-using-month-and-day-in-birthday-filed-using-elasticsearch-sql/284844/1 "2021-09-22T10:13:08Z")
i have a filed name birthday. which has date of birth in Date format.
now using Elasticsearch SQL query, I want get
"list all people who have birthdays in January"
how to get all people using whose birthday is in January.
birthday dates are:
1. 02/04/1995
2. 23/04/1991
3. 21/09/1885
---
### Author:  [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)
#### Post date: [September 23, 2021, 1:56pm UTC](https://discuss.elastic.co/t/search-docs-using-month-and-day-in-birthday-filed-using-elasticsearch-sql/284844/2 "2021-09-23T13:56:47Z")
You can use the month functions in [date/time functions](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-current-date).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 21, 2021, 1:56pm UTC](https://discuss.elastic.co/t/search-docs-using-month-and-day-in-birthday-filed-using-elasticsearch-sql/284844/3 "2021-10-21T13:56:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.