Allow changing the field type from DateTime → Date

We ran into a limitation while working with Date fields that include time.

Our team works across multiple time zones, and we noticed that storing date + time sometimes creates inconsistencies in how entities appear for different users. Because of this, we decided that for this field we only need the date without time.

However, Fibery currently does not allow switching a Date field from date & time → date only.

From a practical standpoint, it would be very helpful if this conversion were still allowed.

Suggestion:

Allow changing the field type from DateTime → Date (no time) even when time values exist, but show a clear warning such as:

“Time values will be removed from existing records.”

The reason this is important is that this field is already used in many formulas and automations in our workspace.

At the moment, the only workaround is to:

  1. create a new field

  2. migrate all data

  3. update every formula and automation that references the old field

This becomes quite time-consuming and error-prone in larger workspaces.

Allowing the field type conversion with a warning would make schema adjustments much easier without breaking existing workflows.

2 Likes

This functionality is more broadly requested here: Add ability to fully edit fields after creation

1 Like

Yes I just tried to upvote over there in fact, good to get the support of this feature!