Field: CreatedAt

Description

The Created At field is a reference field for entities (Requirements, Scripts, Script Assignments and Incidents) and is date/time stamp of when the entity was created.

Supported Formats

The date formats supported are:

You can also include a time component:

Examples

To find all items that were created between 2 dates, you can use the greater than or equal to and less than or equal to operators:

CreatedAt >= "2011-10-24" AND CreatedAt <= "2011-11-02"

Alternative you can use the short-hand range syntax:

CreatedAt IN ["2011-10-24", "2011-11-02"]

See Also

Supported Operators

=, <, >, <=, >=, IN, !=, NOT IN, IS, IS NOT

Supported Indexes

Entity, Run

Supported Types

Supported Features

FeatureSupported?
AggregationYes (DateTime)
SortableYes
Sub-selectsNo