Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

The date/time format is not valid or the value is outside the supported range error on CRM workflow

(0) ShareShare
ReportReport
Posted on by 35

we are getting intermittent error on CRM workflow. Though workflow is successful most of the times, but intermittently we are getting below error and workflow is going in to waiting state. Tried restarting sandbox service and also tried changes with the region on the server.

Error:- The date/time format is not valid or the value is outside the supported range.

pastedimage1610610915027v1.png

DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported: 01/01/1753 00:00:00

Plugin Trace:

[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.SetEntityProperty]
[SetEntityProperty]

Error Message:

Unhandled Exception: Microsoft.Crm.CrmArgumentOutOfRangeException: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported: 01/01/1753 00:00:00
at Microsoft.Crm.BusinessEntities.CrmDateTime.ValidateDateTime(String parameterName, DateTime dateTime, Behavior behavior)
at Microsoft.Crm.BusinessEntities.CrmDateTime.Initialize(DateTime userTime, DateTime universalTime, Behavior dateTimeBehavior)
at Microsoft.Crm.BusinessEntities.DynamicCrmDateTimeBuilder.ConvertToCrmDateTime(DateTime dateTime, IUserAndOrganizationContext userAndOrganizationContext, DateTimeToCrmDateTimeConversionStrategy strategy)
at Microsoft.Crm.BusinessEntities.DynamicCrmDateTimeBuilder.ConvertToDateTime(DateTime sourceValue, IUserAndOrganizationContext userAndOrganizationContext)
at Microsoft.Crm.Workflow.Services.ExpressionServiceBase.SetEntityProperty(ActivityContext executionContext, SetEntityProperty setEntityPropertyActivity)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
Inner Exception: System.ArgumentOutOfRangeException: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported: 01/01/1753 00:00:00
Parameter name: userTime
Actual value was 01-01-0001 00:00:00.

Thanks in advance for help.

  • Suggested answer
    a33ik Profile Picture
    84,329 Most Valuable Professional on at
    RE: The date/time format is not valid or the value is outside the supported range error on CRM workflow

    I understand - because it fails depending on the data it runs with.

    Can you please post the screenshot of the workflow and specific steps where you create/update some data using datetime fields?

  • Ronit Nandgaonkar Profile Picture
    35 on at
    RE: The date/time format is not valid or the value is outside the supported range error on CRM workflow

    Actually all workflows are not failing. we are getting this error intermittently for same workflow.

  • Suggested answer
    a33ik Profile Picture
    84,329 Most Valuable Professional on at
    RE: The date/time format is not valid or the value is outside the supported range error on CRM workflow

    Hello,

    Value 01/01/0001 00:00:00 actually means that the field you try to use the data from is empty. Just add the check if the field is empty - not use it.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,309 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,160 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans