How to disable time in a date field after data is associated

Get Help
1

I would like to remove all time values from a date field but the option is greyed out now that data is associated with the dates. Is there a way to remove it as its causes date to shift due to UTC. I have a lot of data referencing those fields so deleting and create a new one would be a huge undertaking

Thanks

1 Like
2

Yes, it would be nice to be able to “upgrade” or “downgrade” various different field types.

E.g. for numeric fields, to reduce the number of decimal places (truncating data if necessary).

3

Unfortunately, it’s not possible to change a field type from date-time to just date, but if you create a new field, it shouldn’t be too hard to copy the relevant dates over (e.g. using an automation).
If you then delete the original date-time field, then you will be notified if you’ve broken any lookups or formulas that depend on it.