Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

decrement days number

(0) ShareShare
ReportReport
Posted on by 1,670

Hi,

i have field (duration type) of number of days, how i can decrement the number of day (every day) ?

*This post is locked for comments

  • Verified answer
    Hamzeh Zawahreh Profile Picture
    Hamzeh Zawahreh 3,674 on at
    RE: decrement days number

    dear Ammar Zaied,

    you choose one of the following:

    1. Host a service that implements the scheduling functionality and then have this service call into the CRM web service to perform actions regularly.
    2. Leverage the CRM workflow “wait” step.
    3. Alter the recurrence patterns of CRM asynchronous operations (unsupported).

    see this helpful link on create a recurring workflow, but after you read this article the work flow is have to created once on your entity on the first record was created.

    http://gonzaloruizcrm.blogspot.com/2011/05/quite-often-we-have-business-process.html

  • Verified answer
    purwar purwar Profile Picture
    purwar purwar 2,836 on at
    RE: decrement days number

    You can use async type workflow . and  call same workflow as child after 24 hrs.

    I am hoping you are using number type field for decrement.

    You can use "DecrementBy" in workflow.

    For complete solution you can use below link

    mahenderpal.wordpress.com/.../step-by-step-using-decrementby-in-microsoft-dynamics-crm-2011-workflow

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: decrement days number

    Ammar,

    Either you use the Timer control (but need a datetime not number) if for CRM 2013 SP1

    And put it to the CRM Form, yes as mentioned by Wayne, you need to always open it.

    Or like to create an aging field, you need to do batch job updating that day by day every day.

    Hope this helps.

    Thanks,

  • Suggested answer
    Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: decrement days number

    So there are limitations on changing values every day without opening records.  Likely you're going to need an external batch process running on your CRM server that iterates through all your records and decrements that value.  the only other option is to rely on decrementing when someone opens the record.

    The latter should be fine if you only care about that value when they open the record, but not ok if you need to do anything else.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans