Date Picker Column

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.

image

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

Date formats

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.