Date

​

Setting Up Date Fields

​

Adding a Date Field

1. Click “Add Field” in the table view.
2. Name the field and select “Date” as the field type from the dropdown menu.

​

Date Field Options

• Include Time: In addition to the date, you can choose to add specific time information.
• Timezone Selection: Choose a specific timezone for your dates and times (defaults to current timezone), which is particularly important when dealing with international business or team collaboration.
• Formatting Options: Date fields offer various formatting options to suit different needs. For example:
  • YYYY-MM-DD (e.g., 2023-11-03)
  • DD/MM/YYYY (e.g., 03/11/2023)
  • MM/DD/YYYY (e.g., 11/03/2023)
  • D MMM YYYY (e.g., 3 Nov 2023)
  • …and many other format options.

​

Features and Functions

• Date Picker: Built-in date picker tool makes selecting dates easy while ensuring date format accuracy.
• Auto-fill: In specific scenarios, the system can automatically fill in dates and times, such as record creation or last modification dates.

​

Application Examples

• Project Management: Set clear start and end dates for tasks to keep projects on schedule.
• Event Planning: Record dates and times for upcoming events and meetings to ensure nothing is missed.
• Timeline Analysis: Sort and analyze time-series data, such as sales trends or user activity.

​

Combining with Other Fields

• Formula Fields: Combine date fields with formula fields to help calculate date intervals, predict future dates, and more.