Hey all, I was wondering if anyone can help me with a solution: Our organization has yet to receive CRM 2015 Update 1 as we have just received update 2015 and I am wondering if I can do the following with calculated fields.
I want to get the amount of days a record has aged without someone modifying it or setting a follow up date, so I want to use a condition to check this and then return a value of days that the record has aged. I have the condition fine, but I want to know if there's a formula I can use to compare today's date with the follow up date/last modified date and return the number of days for the difference (Note: We do not have the DIFFINDAYS function yet).
Thanks for all the help
*This post is locked for comments
Essentially we're using it for metrics tracking. We're specifically working with the case entity and need to track when team members let cases languish and capture the amount of days that a case has been languishing.
What do you intend to do with this, if you could get it?
Note that you can now create a view such as "Modified On" is Older than X days / weeks / months.
If you want to use this in a Workflow you could use a simple "Wait for Timeout until (say) 30 days after Modified On" to do nothing unless and until the record goes for 30 days without being modified.
Thank you Aileen, I was afraid of that. I suppose we'll just have to wait until we get our update
Matt,
If you have yet receive CRM 2015 Update 1, there wont be any function for the diff days function.
So, you need to customize this, either you use javascript (on form), retrieve plugin, or batch job to keep it updated.
Thanks.
Thank you for the response, but as stated in my post we do not have update 1 yet (Our organization was just updated to 2015 from 2013 and we aren't scheduled to get update 1 until sometime late summer), therefore we do not have the DIFF functions, nor do we have the NOW function. I was asking if there was a way to get this information without these new functions
Dear Mattlore,
Please take a look to : community.dynamics.com/.../new-calculated-field-functions-in-crmonline-update-1
Hope this helps,
Abed.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156