A Date Picker column type can be used to easily enter a date to a cell by selecting it from a dropdown calendar. It can be used to store fields like a project’s start date and due date.

You can change the format of the date displayed by clicking the format option in the properties and then selecting the desired format.

There are four date formats available to choose from

  • Friendly format: Month DD, YYYY
  • US format: MM/DD/YYYY
  • European format: DD/MM/YYYY
  • ISO format: YYYY-MM-DD

The sort option can be used to sort the rows from first to last or last to first based on the value of this column. Read more about sort here.

You can use conditional formatting to better visualize the entries in each cell. For more details on conditional formatting options you can refer to this.

Did this answer your question?