Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    Abed Haniyah Profile Picture
    Abed Haniyah 4,285 on at
    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans