# SQL - using date range

**URL:** <https://forum.opensearch.org/t/sql-using-date-range/5945>\
**Category:** SQL\
**Created:** [May 14, 2021, 8:22pm UTC](https://forum.opensearch.org/t/sql-using-date-range/5945 "2021-05-14T20:22:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![unseokyeo](https://avatars.discourse-cdn.com/v4/letter/u/e19adc/32.png) [@unseokyeo](https://forum.opensearch.org/u/unseokyeo)\
**Post date:** [May 14, 2021, 8:22pm UTC](https://forum.opensearch.org/t/sql-using-date-range/5945/1 "2021-05-14T20:22:17Z")

</div>

I am trying to port existing SQL to Opendistro and struggling with using date ranges.  
When I fire a query with "**WHERE date\_format(my\_date\_field, ‘yyyy-MM-dd’) \> '2021-01-01**’, everything works fine. However, if I add "**AND date\_format(my\_date\_firld, ‘yyyy-MM-dd’) \< '2021-01-31**’ ES simply returns nothing - no errors or exceptions.

Appreciate everyone in advance for your knowledge.

I am currently testing with ES v7.9 and v.7.10

Cheers

---

<div class="post-metadata">

**Author:** ![daichen](https://avatars.discourse-cdn.com/v4/letter/d/c4cdca/32.png) [@daichen](https://forum.opensearch.org/u/daichen)\
**Post date:** [June 7, 2021, 8:27pm UTC](https://forum.opensearch.org/t/sql-using-date-range/5945/2 "2021-06-07T20:27:32Z")

</div>

Hi @unseokyeo , could you provide more info about your index mapping and data? So we can reproduce the issue from our side. Thanks!