DATE criteria date format specifications
Parent: DATE Criteria · Published reference · snapshot 2026-10-15
↓ Facts as markdownall context files
Depth-first rabbithole dossier for DATE criteria date format specifications; source-anchored research pack.
These notes link each claim to its source. Some citations identify archived research reports that are no longer hosted on this site. A published reference means the content is available; it does not certify independent review or accuracy.Read the editorial policy and follow the sources before relying on a claim.
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]
- [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]
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]
- [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]
- [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]
- [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]
- [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]
- [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]
- [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]
- [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]
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
Children
- No children recorded.