A Date field stores a specific date or point in time, such as a project deadline, meeting time, or employee start date. It can show only the date, or include a time such asDocumentation Index
Fetch the complete documentation index at: https://help.teable.ai/llms.txt
Use this file to discover all available pages before exploring further.
2025-11-03 14:30.
Use Cases
| Scenario | Good for |
|---|---|
| Project scheduling | Task start dates, deadlines, milestone dates |
| Event planning | Meetings, events, appointments, release plans |
| People and contract records | Start dates, signing dates, expiration dates |
| Period reporting | Filter and report data by week, month, or quarter |
Create and Configure
Configure date options
Set the date format, whether to include time, the time format, and the time zone as needed.
Date Field Options
| Option | Description |
|---|---|
| Include time | Store a specific time in addition to the date |
| Date format | Controls date display, such as YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, or D MMM YYYY |
| Time format | Controls whether time is shown, and whether it uses 12-hour or 24-hour time |
| Time zone | Sets the time zone used for dates and times, useful for teams across regions |
| Auto-fill current time | Fills new records with the current time when they are created |
Common Uses
- Task scheduling: Record start dates and due dates, then sort or filter by due date.
- Event planning: Record meeting and event times so important dates are easy to track.
- Period reporting: Filter data for this week, this month, or a custom date range.
- Date calculations: Reference Date fields in Formula fields to calculate intervals between dates.