Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Calculated Field on Import solution : You can only use a Date Only type

Posted on by 66

Hi,

I'm importing the unmanaged solution to the CRM system and getting below error on custom calculated field 

Data type: Date & Time

Behaviour: Date Only

Format: Date only.

Please suggest. Much appreciate if you would respond quickly.

Regards,

Sumit 

*This post is locked for comments

  • EDM1 Profile Picture
    EDM1 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Sumit,  I am having the same issue.  The field works fine in development, but I cannot import a solution with this field into a clean CRM instance.  My field is defined as DateTime, Date Only behavior, Date Only format.  It is a Calculated Field producing Today's Date using the Now() function to compare to other Date Only fields within the entity.

  • Sumit Desai Profile Picture
    Sumit Desai 66 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Its a Custom field, there is a schema name but i purposely removed that. Its failing there only at this field as per the log file . I cant remove this field. its has dependancy  

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Hi Sumit,

    You sure its a custom field cause it says opportunity.currentdate, I would expext the schema name as well if this is a custom field like new_currentdate.

    Is it possible for you to remove the field from the solution and then try again. This will confirm if this is because of the field or something else.

    If this doesn't help, you can also break your solution into small sub solution and then track where exactly its failing (may be entity wise).

  • Sumit Desai Profile Picture
    Sumit Desai 66 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Thanks

    Target environment is the fresh copy of CRM solution and this field is custome filed in a source environment

  • Suggested answer
    Bhaargavi Bodapati Profile Picture
    Bhaargavi Bodapati 115 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Hi Sumit,

    Check if there is a mismatch in the data type of the field within the 2 environments where you are trying to import

  • Sumit Desai Profile Picture
    Sumit Desai 66 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    07:21:49.45 Field Opportunity.currentdate Failure 0x8006043A You can only use a Date Only type of field

    This message is  what in log file I downloadedCRM-err.png

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Hi Sumit,

    This information may not be enough to suggest anything. Could you please share some more details like the error message, log file & screenshot.

  • Sumit Desai Profile Picture
    Sumit Desai 66 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    07:21:49.45 Field Opportunity.currentdate Failure 0x8006043A You can only use a Date Only type of field.

  • Bhaargavi Bodapati Profile Picture
    Bhaargavi Bodapati 115 on at
    RE: Calculated Field on Import solution : You can only use a Date Only type

    Could you post a screenshot and log record of your error?

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans