How to Index Date Fields

You can use the Atlas Search date type to index date values. You can query fields of type date using the Atlas Search range, near, in, and equals operators. You can also run a facet query on date type fields.

You can also use the date type to index:

• Fields whose value is an array of dates. To learn more, see How to Index the Elements of an Array.

• Date fields inside an array of documents indexed as the embeddedDocuments type.

• Date fields for sorting. Atlas Search automatically indexes all date fields in indexes created after July 2023 for sorting the Atlas Search results. For preexisting indexes, you must rebuild the index to use date fields in the index for sorting. To learn more, see Update an Existing Index and Sort Atlas Search Results.

If you enable dynamic mappings, Atlas Search automatically indexes fields of type date. You can use the Visual Editor or the JSON Editor in the Atlas UI to index fields as the date type.

1
{
2
  "mappings": {
3
    "dynamic": true|false,
4
    "fields": {
5
      "<field-name>": {
6
        "type": "date"
7
      }
8
    }
9
  }
10
}

1
{
2
  "mappings": {
3
    "dynamic": false,
4
    "fields": {
5
      "released": {
6
       "type": "date"
7
      }
8
    }
9
  }
10
}

1
{
2
  "mappings": {
3
    "dynamic": false,
4
    "fields": {
5
      "released": [
6
        {
7
          "type": "date"
8
        },
9
        {
10
          "type": "dateFacet"
11
        }
12
      ]
13
    }
14
  }
15
}