Date

Definition of Date, 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)

• Dateis a data type found in our Objects, Lists, List Columns, and Outbounding Metrics

• Date allows for math operations, and date range operations

• Dateis similar to Timestamp, but provides less granularity, only providing the Month, Date, and Year.

• Timestamp will typically stamp based on a default, fixed timezone regardless of operation or user location (commonly, UTC Timezone).

Examples

• A field called "Birthday" in a table.

Typical Usage in Sorts & Filters

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

• Filtering Date 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'