Standard column type
Date
A Date column stores a date or date time. Dates are what time based operations key on: expirations trigger reminders, due dates drive overdue queues, and hire dates anchor onboarding timelines.
Illustrative example
Dates and times: expirations, due dates, and anything workflows schedule around.
- 01
Table
Documents
- 02
Field
Expiration date
- 03
Purpose
Drives the Expiring soon and Expired tabs.
A suggested way to organize your information. This diagram is not a product screen.
When to use this type
- 1Expiration dates that compliance workflows watch.
- 2Due dates that drive overdue tabs and escalations.
- 3Hire dates, start dates, and review periods.
Column ideas for your team
Documents
Expiration date
Drives the Expiring soon and Expired tabs.
Placements
End date
Feeds the Ending soon queue.
Good to know
- 1Workflows can trigger relative to a date; 30 days before expiration, the day after a start date.
- 2Use date time only when the time of day matters; plain dates filter more cleanly.