Use case or problem
I would like to display a property in a base with the following features:
- the property is of the date type
- the date can be edited by clicking on it
- the date can be shown in relative format (and possibly others)
At the moment, I can achieve (1) and (2) by showing a date property in default YYYY-MM-DD format, or I can achieve (1) and (3) by using a formula of the kind date.relative(), which creates a text string rather than a date proper, but I cannot achieve (2) and (3) simultaneously.
Proposed solution
Add formatting options (or arbitrary formulae) to date properties in bases while retaining click-to-edit. If it would be difficult to apply click-to-edit to relative dates, then just keep the prepended calendar icon to allow for the calendar popup.