Skip to main content

Date

Date fields store date and time values.

View all settings
SettingDescription
Field NameText input, required. Unique identifier for the field.
Input TypeDropdown, required. Choose Date, Date Time, Month, or Week.
Default ValueDropdown. None, Specific Date, or Current Date/Time.
Display LabelText input. Human-readable label shown in forms.
Sort OrderNumber input, defaults to 0. Position in field lists.
IconIcon picker. Visual identifier.
StatusToggle, defaults to true. Enable or disable the field.
RequiredCheckbox. Make the field mandatory.
DescriptionText area. Documents the field's purpose.
Form VisibilityDropdown. Show in Add, Edit, or Both forms.
DB Field NameText input. Custom database column name.
Faker TypeDropdown. Generate test data.
Use as IndexCheckbox. Create database index for performance.
Populate from Logged-In UserCheckbox. Auto-fill from user session.
Start DateDate picker. Earliest allowed date.
End DateDate picker. Latest allowed date.

Input Types

  • Date — Date only (YYYY-MM-DD), no time component
  • Date Time — Full date and time with timezone support
  • Month — Month and year selection (YYYY-MM)
  • Week — Week number and year selection

When to Use

Choose Date when:

  • You need to store dates, times, or timestamps
  • Scheduling events, deadlines, or appointments
  • Tracking creation or modification times
  • Filtering or sorting by date ranges

Settings

See Common Settings for shared options.

Not available: Primary Key, Unique

Default Value (Basic Settings)

Dropdown with three options:

  • None — No default value
  • Specific Date — Opens a date picker to select a fixed date
  • Current Date/Time — Uses the current date/time when the record is created

When Current Date/Time is selected, additional options appear:

SettingDescription
OperationAdd (+) or subtract from the current date.
UnitDays, Weeks, Months, or Years.
ValueNumber to add/subtract (e.g., 7 days from now).

Validation (Advanced Settings)

SettingDescription
Start DateEarliest allowed date.
End DateLatest allowed date.

Use Cases

  • Event dates and deadlines
  • Birthdays and anniversaries (Date)
  • Appointment scheduling (Date Time)
  • Due dates with dynamic defaults (e.g., 30 days from now)
  • Monthly or weekly reporting periods