130
Hi,
I have calculated Age value and assigned it to a field on change of a Date field.
How can I make this Age value incremented by 1 Day on daily basis ?
And I can not use on demand workflow as there are large number of records.
Is there any alternative way to achieve the functionality ?
*This post is locked for comments
So since you're on premises, I recommend writing a batch application that runs nightly. You can even use Windows Scheduling to run it if you don't want to make it a full service. That's the only way to reliably manually update a field in CRM.
Yes, the field needs to be updated every day for all the records of the entity in Years Months Days format
Hi,
There's not a great way to do it in 2011. With CRM 2015+ you would use a calculated field for this but that's not available in 2011.
There are a few ways to handle this, but I think it's important to know the business case. Does it really need to be updated every day? Does it matter if it's up to a week out of date? If it's an individual's age, does 37 years, 4 months and 5 days really matter?
If you want a field for an end user to see on the form, I would do it with a web page embedded on the form in an IFrame. Your page will do the calculation, so somebody will always see up to date information.
If you NEED a field with the actual value, you'll need some external service that runs every day and updates the records (you could try to do it with workflows that launch themselves as child workflows but that's super susceptible to failure).
Hope this helps! I'd appreciate if you'd mark this as Answering your question.
Thanks,
Aiden
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (