Date Field

The Date Field can be used to store dates, date ranges and a date and time combination. The Text Field is most commonly used to store:

  • Schedules (e.g: the Event’s scheduled start time and end time)
  • Deadlines (e.g: the Project’s Deadline)

Note: You can visualize records with a set date in your calendar.

Adding a Date Field

Learn how you can add a new Field in Fusioo. Here are some of the Text Field’s additional options:

Default Value A Default Date is added automatically when creating a new record.
Default date

Note: You can set the default date in the past by entering a negative number.

Date Type
  1. Date - Used when you need to track a particular date.
  2. Date and Time - Used when you need to track both the date and time (no interval).
  3. Date Range - Used when tracking a time interval.
Date types
Display count from today When ticked, the date will be displayed as a count from the current date (now). For example, 5 days ago OR in 16 days.

Here’s how the Field will appear when you are:

  • Creating a new record
    While creating record

     

  • Viewing a record
    While viewing a record

     

  • In the List View
    In the list view

     

  • In the Badge View
    In the badge view

     

Additional Information

Can be used for searching? No
Can be used to sort records? Yes
Can be used as a Badge Heading? No
Can be used for grouping in the Kanban Board? No
Filtering options
  • Is after
  • Is before
  • Equal to
  • Not equal to
  • Is today
  • Is within next
  • Is within previous
  • Is within previous week
  • Is within current week
  • Is within next week
  • Is within previous month
  • Is within current month
  • Is within next month
  • Is within previous year
  • Is within next year
  • Is within next year
  • Is not empty
  • Is empty
What would you improve in this article?