# Date fields not being returned in results

**URL:** <https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416>\
**Category:** Elastic Search\
**Created:** [July 12, 2022, 12:28pm UTC](https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416 "2022-07-12T12:28:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rav\_Panchalingam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rav_panchalingam/32/106902_2.png) [@Rav\_Panchalingam](https://discuss.elastic.co/u/Rav_Panchalingam)\
**Post date:** [July 12, 2022, 12:28pm UTC](https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416/1 "2022-07-12T12:28:33Z")

</div>

Hello, we have Elastic App Search via Elastic Cloud. Version 8.3.2

When we index documents with a Date field, that field does not appear in results and we cannot filter using that field.

Here is an example document indexed in the engine:

```auto
{
	"status": 10,
	"status_text": "In Progress",
	"ext_id": "QAC.20190820",
	"da_key": "QAC.20190820",
	"stage_name": null,
	"address": "22 Clark Road, Morayfield QLD 4506",
	"decision_date": "2021-02-02 06:57:41Z",
	"description": "1 into 23 lot residential subdivision",
	"applicants": [
	  "ABC Developments Pty Ltd"
	],
	"tags": null,
	"land_parcels": [
	  "1RP811523"
	],
	"location": "-27.126452, 152.956069",
	"record_id": 278,
	"id": "application-278",
	"record_type": "Application",
	"link": "charges-manager/applications/278"
}

```

Here is the result returned on search, no `decision_date` field:

```auto
{
	"address": {
		"raw": "22 Clark Road, Morayfield QLD 4506"
	},
	"applicants": {
		"raw": [
			"ABC Developments Pty Ltd"
		]
	},
	"link": {
		"raw": "charges-manager/applications/278"
	},
	"description": {
		"raw": "1 into 23 lot residential subdivision"
	},
	"record_type": {
		"raw": "Application"
	},
	"tags": {
		"raw": null
	},
	"record_id": {
		"raw": 278.0
	},
	"ext_id": {
		"raw": "QAC.20190820"
	},
	"da_key": {
		"raw": "QAC.20190820"
	},
	"stage_name": {
		"raw": null
	},
	"location": {
		"raw": "-27.126452, 152.956069"
	},
	"status_text": {
		"raw": "In Progress"
	},
	"_meta": {
		"id": "application-278",
		"engine": "np-local-search-np-lt-11-demo",
		"score": 6.594488
	},
	"id": {
		"raw": "application-278"
	},
	"land_parcels": {
		"raw": [
			"1RP811523"
		]
	},
	"status": {
		"raw": 10.0
	}
}

```

When I do a filter like this it returns 0 results:

```auto
"filters": {
        "decision_date": {
            "from": "2020-01-01 00:00:00Z",
            "to": "2023-01-01 00:00:00Z"
        }
    }

```

The field exists inside schema with correct type assigned

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/f/cfcecc68a105fd4eb1d005c36a23685b793461d3.png)

Can someone please help; what am I doing wrong here?

---

<div class="post-metadata">

**Author:** ![Carlos\_D](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_d/32/126245_2.png) [@Carlos\_D](https://discuss.elastic.co/u/Carlos_D)\
**Post date:** [July 18, 2022, 8:28am UTC](https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416/2 "2022-07-18T08:28:23Z")

</div>

hi @Rav_Panchalingam !

Dates in App Search should be included in [ISO 8601 format](https://www.elastic.co/guide/en/app-search/current/api-reference.html#overview-api-references-date).

Can you please check that dates ingested with this format behave correctly?

Please let us know!

---

<div class="post-metadata">

**Author:** ![Rav\_Panchalingam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rav_panchalingam/32/106902_2.png) [@Rav\_Panchalingam](https://discuss.elastic.co/u/Rav_Panchalingam)\
**Post date:** [July 18, 2022, 9:32am UTC](https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416/3 "2022-07-18T09:32:30Z")

</div>

that worked, thank you

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 15, 2022, 9:32am UTC](https://discuss.elastic.co/t/date-fields-not-being-returned-in-results/309416/4 "2022-08-15T09:32:58Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.