Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Calculated Field for day calculation

(0) ShareShare
ReportReport
Posted on by 340

Hi All,

I have one Whole Number Calculated Field which is calculating different in days from created on record to today's date.

But I want to stop it's calculation once Number of Days equals to 7 or something...... 

plz suggest me How I can stop it's calculation? Because it is keep on calculating.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated Field for day calculation

    Hey Alok,

    It's not supposed to do that, but it seems to be a bug in the Duration format. Recreate the field and select 'None' under Format when creating it and it will just be the whole number instead.

    Hope that helps.

  • Alok Sharma Profile Picture
    Alok Sharma 340 on at
    RE: Calculated Field for day calculation

    It is calculating DiffInDays property for calculated field but those days It is showing In minutes.

    It is showing correct value but instead of Days It is giving minutes like: today it is 1 day but it is showing 1 minutes. if tomorrow it will show 2 minutes.  

  • Verified answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,076 on at
    RE: Calculated Field for day calculation

    Hi Alok Sharma,

    You can’t trigger workflows or plug-ins on calculated fields. This is one of limitation of calculated fields in dynamics CRM.

    Hope this helps.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated Field for day calculation

    I think there are limitation to Calculated field: Refer this:

    www.summitgroupsoftware.com/.../limitations-calculated-fields-microsoft-dynamics-crm-2015

    You should do it by using a simple whole number field and do the calclation using realtimeworkflow and put a condition there.

  • Alok Sharma Profile Picture
    Alok Sharma 340 on at
    RE: Calculated Field for day calculation

    whenever I'm selecting same calculated field in workflow it is saying can't select calculated field.  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated Field for day calculation

    You can use the field validation to achieve this. Set the maximum field limit to 7.

    Or You can write a workflow to calculate the duration and add the limit

  • Alok Sharma Profile Picture
    Alok Sharma 340 on at
    RE: Calculated Field for day calculation

    Hi Mohd,

    But same field is not listing in condition section. So how I can put ?

    I also tried same .

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated Field for day calculation

    Please put a if condition to check if calculated field is less than or equal to 7 while calculating the number of days

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans