Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Date issue dynamics

Posted on by 5

I have a custom table in my dynamics environment. This custom table store information on employments, and include a start date field. I have a view on this table which is displayed on a subgrid on the main form of the contact table. The view contains the start date field.

Some of the employments have been migrated to dynamics and have the start date 1899-12-31T23:00:00Z. The field has user local behaviour and all users are located in UTC+2. The date is displayed as1899-12-31 on the form. 

However, on the view in the subgrid, the date displays as 1900-01-01. I have no clue as to why the date differ between the form and the view on the same entity. Any ideas? 

  • Ken Hubbard Profile Picture
    Ken Hubbard on at
    RE: Date issue dynamics

    Hello, 

    This sounds like something with reproducible behavior. I tried reproducing this but could not. 

    What is the product version and field settings for the date field? Specifically, what is the Behavior and Format types?

    Does the behavior match the expectations set here in regards to behavior?

    Behavior and format of the date and time attribute (Developer Guide for Dynamics 365 Customer Engagement (on-premises)) | Microsoft Docs

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans