Skip to main content

Notifications

Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / Problems with date typ...
Microsoft Dynamics CRM forum
Suggested answer

Problems with date type fields with January 1900 dates

editSubscribe (0) ShareShare
ReportReport
Posted on by DS-29040812-0 3
Entering dates to January 1900 reduces one or two days to the date entered. 

Passes with date type fields (Date only). I've tried all types of time zone settings because that would be the problem, but it doesn't seem to be the case. 

For example, in the CRM I put a date of January 1, 1900 and it changes it to December 31, 1899. But, if I put a date after January 1900 the date doesn't change.

 
 
 
Categories:
Other
Development / Customization / SDK
  • Suggested answer
    DS-29040812-0 Profile Picture
    DS-29040812-0 3 on at
    Problems with date type fields with January 1900 dates
    I have conducted tests after your response, but the dates in the Dataverse table still appear incorrect to me.
    The View
    WebAPI
    Time zone


    What I don't understand is why they appear incorrect in the view and table, but in the form and in the webAPI it shows what it should show.
     
    Could it be because of the time zone? And why only with dates prior to January 1900? Why don't you change the other dates?
     
    Thanks
     
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Problems with date type fields with January 1900 dates
    Hi,
     
    In my testing I found that this is related to the time zone the user is in.
    I have created the following three date fields in the contact entity with the following behavior: Date Only,User Local and Time zone independent.
     
    The current time zone is GMT+12.
     
    In Dataverse you can see that the time zone adjustment is set to the User Local field is affected by the time zone and the date is reduced one day.
    And the other two fields are unchanged.
     
    The same results are fetched through the WebAPI.
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans