# DATE criteria date format specifications > Depth-first rabbithole dossier for DATE criteria date format specifications; source-anchored research pack. Parent: [DATE Criteria](https://llms-explorer.com/tree/date-criteria/) · 2 facets · 10 facts · page: https://llms-explorer.com/tree/date-criteria-date-format-specifications/ ## Problems, failure modes and limitations - [low] Once an online archive is created, you cannot modify the date field. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] You cannot use the _id field as the date field for an Online Archive. (verified as of 2026-10-15) Sources: https://mongodb.com/community/forums/t/online-archive-using-id/277894 — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#troubleshooting` ## Facts and statements - [high] The valid date format values for the DATE criteria are ISODATE, EPOCH_SECONDS, EPOCH_MILLIS, EPOCH_NANOSECONDS, or OBJECT_ID, with ISODATE as the default. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md, https://www.mongodb.com/docs/atlas/cli/current/command/atlas-clusters-onlineArchives-create.md, https://raw.githubusercontent.com/mongodb/terraform-provider-mongodbatlas/master/docs/resources/online_archive.md, https://www.pulumi.com/registry/packages/mongodbatlas/api-docs/onlinearchive/ — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] If the date format is set to EPOCH_SECONDS, EPOCH_MILLIS, or EPOCH_NANOSECONDS, the value of the specified date field must be of the BSON type long. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [high] If the collection type is TIMESERIES, you must set the criteria type to DATE. Sources: https://raw.githubusercontent.com/mongodb/terraform-provider-mongodbatlas/master/docs/resources/online_archive.md, https://www.pulumi.com/registry/packages/mongodbatlas/api-docs/onlinearchive/ — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] If DATE is selected as the criteria type, the partition_fields.field_name must be completed with the dateField value. Sources: https://www.pulumi.com/registry/packages/mongodbatlas/api-docs/onlinearchive/ — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] Documents matching the criteria are those where the current date is greater than the value of the date field plus the number of days specified via the expire_after_days parameter. Sources: https://github.com/mongodb/terraform-provider-mongodbatlas/issues/1081 — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] A sample criteria configuration uses type DATE, date_field timestamp, date_format ISODATE, and expire_after_days 7. Sources: https://github.com/mongodb/terraform-provider-mongodbatlas/issues/1081 — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] The date field must be an already indexed date field from the documents and is mutually exclusive with the --file parameter. Sources: https://www.mongodb.com/docs/atlas/cli/current/command/atlas-clusters-onlineArchives-create.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` - [low] The criteria.dateField parameter defaults as the first item in the partition sequence. Sources: https://www.pulumi.com/registry/packages/mongodbatlas/api-docs/onlinearchive/ — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/date-criteria-date-format-specifications-f85a69f1fe/rabbithole-synthesis.md#core` ## Related concepts - DATE — is a part of DATE criteria date format specifications - criteria — is a part of DATE criteria date format specifications - format — is a part of DATE criteria date format specifications