Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Dynamics 365 Contact table: Error code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00

Posted on by 3,962

I've read solutions to this error and know about formatting dates. In my case I'm not loading any dates into my Dynamics 365 Contact table.  There are no 'required' date fields, that I see in the table, column list. Why would I get this error?

 

Flirstname

Lastname

Email

customfield Yes/No

customfield2 yes/No

externalkey int

 

somehow the contact table is rejecting a date..... what column do I need to provide to supress this error? What is the differenct between a Managed Column and Standard column?

 

 

  • RE: Dynamics 365 Contact table: Error code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00

    HI @ncfusion , 

    If you get an error regarding to a date, but you don't set any date, then I thought that maybe in your environment are some PlugIns or sync workflows registered.
    Maybe somebody else programmed something there, which get triggered every time you make a create/update/upsert. This could also cause this kind of errors.

    Kind regards,

    Diana

  • RE: Dynamics 365 Contact table: Error code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00

    Diana, 

    I'm not quite following your question so probably not. I've not used/created and Flows. I'm working with Dataflows. Further I now uderstand Dataflows are not suitable for Upserts (as of this writing)   I've since moved over to ADF Azure Data Factory with some success.   Are you suggesting Flows here when you refer to Steps?

  • RE: Dynamics 365 Contact table: Error code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00

    HI @ncfusion , 

     

    Have you checked if there is a PlugIn or Sync Workflow registered on your step (create / update)? 

     

    Kind regards,

    Diana

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans