web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / What happens to old re...
Customer experience | Sales, Customer Insights,...
Suggested Answer

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

(2) ShareShare
ReportReport
Posted on by Ronak 48

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 (1)
  • Daniyal Khaleel Profile Picture
    Daniyal Khaleel 760 Most Valuable Professional on at
    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).
  • CU26091412-0 Profile Picture
    CU26091412-0 9 on at

    • Stored values do not change – the full datetime (including hours/minutes/seconds) is still in the database.


    Display changes – Dataverse simply applies a rule that strips off the time portion when rendering.


    Example

     

    •  

      Before: 2025-09-23 15:45:00 (UTC)


    •  

      After switching: displayed as 2025-09-23

  • CU08121018-0 Profile Picture
    CU08121018-0 2 on at
    After changing a field from Date and Time to Date Only in Dataverse, the time part of existing records is removed, keeping only the date. All old and new records will now display correctly as dates without times, but double-check any custom forms or views to make sure they’re not still set to show the time of capcut.
  • CU08121016-0 Profile Picture
    CU08121016-0 2 on at
    same question.
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 3,076 Super User 2026 Season 1 on at
    Since we've had a few different answers in here, I decided to test it out for you as I wasn't entirely sure myself. I am creating and updating a field and checking the value in Dataverse through the table view, in a query with XRM Toolbox, and on a system form
     
    Date and Time Format (User Local) field created and a value added through Power Platform
     
    Location Value Notes
    Power Platform 12/8/2025 10:00 AM Time shown in CST based on personal settings
    Query 12/8/2025 4:00 PM Value stored in Database in UTC
    System View/Form 12/8/2025 10:00 AM Time shown in CST based on personal settings
     
     
    Now I am going to update the field to be Date Only, and I published the table and refreshed metadata in XRM toolbox.
     
    Location Value Notes
    Power Platform 12/8/2025  
    Query 10/8/2025 4:00 PM  
    System View/Form 12/8/2025  
     
    Now, I'll change the value of this field in Power Platform to tomorrow's date.
     
    Location Value Notes
    Power Platform 12/9/2025  
    Query 12/9/2025  
    System View/Form 12/9/2025  
     
     
    Summary
    When a date and time field is changed to Date Only, the original value with time remains in the database until the field has been modified. When the change occurs, the time is then dropped off.
     
    If this response helped, please consider marking as verified so future users can see the resolution. If you have additional questions or problems, please tag me in the response so I receive a notification.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 164 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 51 Most Valuable Professional

#3
NeerajPawar Profile Picture

NeerajPawar 42

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans