Microsoft Dynamics CRM (Archived)

decrement days number

(0) Share

Report

Posted on by Ammar Zaied

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

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Wayne Walton 13,730 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (2)

Report

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,

Was this reply helpful? Yes No
Verified answer

purwar purwar 2,836 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

Hamzeh Zawahreh 3,674 on at

Like (1)

Report
RE: decrement days number

dear Ammar Zaied,

you choose one of the following:

Host a service that implements the scheduling functionality and then have this service call into the CRM web service to perform actions regularly.

Leverage the CRM workflow “wait” step.

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

Was this reply helpful? Yes No