elasticsearch range query not working just gives empty response

Issue is that you created index without defining the explicit mapping for Elasticsearch index and your date field is not in the format Elasticsearch supports to detect automatically, and that way your date field is indexed as text and keyword as shown below

 "mappings": {
            "properties": {
                "Date": {
                    "type": "text",
                    "fields": {
                        "keyword": {
                            "type": "keyword",
                            "ignore_above": 256
                        }
                    }

                }

And range query is not supported on the text fields, hence you are not getting result for your query.

Solution

Although Elasticsearch detects data field automatically but it needs to be in below formats as explained in the official doc

[ "strict_date_optional_time","yyyy/MM/dd HH:mm:ss Z||yyyy/MM/dd Z"]

So, either you change your date format if you are not defining the explicit mapping for your index, or define explicit mapping with date field in the format you want to fix issue

One quick check is the type of "Date" in the ES index mapping a datetime type with a specific format. If so the following query may be worth a try

try the boolean query

www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

GET favorite/_search
{
  "query": {
    "bool": {
      "must":[ 
              {
                "range": {
                  "Date": {
                    "gte": "07/12/2022 16:04:30.496",
                    "lte": "07/12/2022 17:05:30.496"
                  }
                }
              }
      ]
    }
  }
}