Date and Time

For instructions on how to access field types or how to add one, see Field Types.

Capabilities

• Store a date and hour value together in one field
• Select date and time via a calendar picker and hour panel, or by typing
• Filter and sort records by date and time
• Use the value in Formula fields for timestamp-based calculations
• Reference the field in automations as a trigger condition or action value
• Track clock-in/out times, meeting schedules, and deadlines with time precision

How to add a Date and Time field

1. Open your table and click + to add a new field.
2. Select Date and Time from the field type list.
3. Enter a name for the field.
4. Optionally mark the field as Required.
5. Click Create.

Use Cases and Examples

• In a "Meetings" flow, a Date and Time field can store the exact date and hour of each meeting.
• In an "HR" table, it can track employee clock-in and clock-out times.
• In a "Sales" flow, it can record the timestamp of when a deal was created or updated.
• In a "Tasks" table, it can hold a deadline with a specific time, such as an end-of-day submission.

Keep in Mind

• Time precision is limited to hours — minute-level precision is not available in the picker.
• The field does not automatically set the current date and time when a record is created — configure this via an automation if needed.

FAQ

1 — What is the difference between Date and Date and Time?

The Date field stores only a calendar day. The Date and Time field stores a day plus a specific hour, making it suitable for scheduling events and tracking timestamps.

2 — Can I use a Date and Time field in a formula or automation?

Yes. Date and Time fields can be referenced in Formula fields to calculate durations or compare timestamps. In automations, you can use them as trigger conditions (e.g., fire when a meeting time is reached) or as values to set in actions.