web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Calculated Field for d...
Microsoft Dynamics CRM (Archived)

Calculated Field for day calculation

(0) ShareShare
ReportReport
Posted on by Alok Sharma 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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

  • Alok Sharma Profile Picture
    Alok Sharma 340 on at

    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 on at

    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

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

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Verified answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,078 on at

    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.

  • Alok Sharma Profile Picture
    Alok Sharma 340 on at

    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.  

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans