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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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

(0) ShareShare
ReportReport
Posted on by 8

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?

 

 

I have the same question (0)
  • Power Platform Communities Profile Picture
    8 on at

    HI @ncfusion , 

     

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

     

    Kind regards,

    Diana

  • Power Platform Communities Profile Picture
    8 on at

    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?

  • Power Platform Communities Profile Picture
    8 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 60 Most Valuable Professional

#2
#ManoVerse Profile Picture

#ManoVerse 51

#3
Satyam Prakash Profile Picture

Satyam Prakash 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans