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) Share

Report

Posted on by Power Platform Comm...

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

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?

All responses (3)

Answers (0)

Sort by

Power Platform Comm... 8 on at

Like (0)

Report
Copy link

Link copied!

HI @ncfusion ,

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

Kind regards,

Diana
Power Platform Comm... 8 on at

Like (0)

Report
Copy link

Link copied!

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 Comm... 8 on at

Like (0)

Report
Copy link

Link copied!

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