Comparing a date field with today's date (calculated field)

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

Thank you Aileen, I was afraid of that. I suppose we'll just have to wait until we get our update

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

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

Was this reply helpful? Yes No
Suggested answer

Abed Haniyah 4,287 on at

Like (0)

Report

RE: Comparing a date field with today's date (calculated field)

Dear Mattlore,

Please take a look to : community.dynamics.com/.../new-calculated-field-functions-in-crmonline-update-1

Hope this helps,

Abed.

Was this reply helpful? Yes No