Timestamp

Definition of Timestamp, a data type, with examples and typical usage in sorts and filters.

In object-oriented programming, structured databases, and CRMs, fields/attributes/columns will often have defined Attribute Data Types.

Definition(s)

• Timestamp (also known as DateTime) is a data type found in our Objects, Lists, List Columns, and Outbounding Metrics

• Timestamp allows for math operations, and date range operations

• Timestampis similar to Date, but provides more granularity. Instead of just the Month, Date and Year, the time (sometimes down to the minute, sometimes down the the second) is also included.

• Timestamp is typically formatted in UI to be something human-readable, because in raw format, it typically looks ugly like 2025-10-23 21:54:54.015764+00

• Timestamp will typically stamp in a default, fixed timezone regardless of operation or user location (commonly, UTC Timezone), with timezone adjustments being made in the UI to handle human-usability based on where the human looking at the data is located. This allows for objective standardization of timestamps.

Examples

• A field called "Last Dialed" in a table.

Typical Usage in Sorts & Filters

• Sorting Timestamp will typically involve sorting earliest to latest, or latest to earliest.

• Filtering Timestamp typically provides the following options:

  • 'is exactly' aka 'exactly matches' aka 'is equal to' aka '=' aka 'is' aka 'equals'

  • 'is not' aka 'does not exactly match' aka 'is not equal to' aka '!=' aka '<>' aka 'does not equal'

  • 'greater than' aka 'is greater than' aka 'later than' aka 'after'

  • 'less than' aka 'is less than' aka 'earlier than' aka 'before'

  • 'greater than or equal to' aka 'is greater than or equal to' aka 'on or later than' aka 'on or after'

  • 'less than or equal to' aka 'is less than or equal to' aka 'on or earlier than' aka 'on or before'

  • 'is between'