What happens to old records if a Date and Time field is changed to Date Only in Dataverse?

(0) Share

Report

Posted on by Dyanmics User

I have an Start Date field in Dataverse. Initially, this field was set as Date and Time with timezone behavior,Now, I changed the field to store Date Only.

I want to understand:

What happens to the existing records that already have both date and time stored?
How can I make sure both old and new records show the correct date without time in forms and the database?

Categories:

Dynamics 365 Sales

I have the same question (0)

All responses (1)

Answers (0)

Daniyal Khaleel 425 on at

Like (0)

Report

What happens to old records if a Date and Time field is changed to Date Only in Dataverse?

The stored values in the database don’t change immediately.
Your old records still have the underlying datetime value stored.
When you flip the field to Date Only, Dataverse applies a rendering rule that hides the time part and displays only the date.
Example:
Original record: 2025-09-23 15:45:00 (UTC)
After change to Date Only: displayed as 2025-09-23 (time hidden).

Was this reply helpful? Yes No