Skip to main content

Notifications

Announcements

No record found.

Power Platform integration forum
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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans