Advanced find - Case modified older than 4 hours RRS feed

  • Question

  • Hi there,

    For CRM 2011 on premise

    I'd like to have an advanced find date option that says "Older that x hours" as i'd like to find cases that have not been modified for 4 hours.  (there already is an older than x months option).

    Or if there was a way to add a NOT function to a clause we could do this with cases edited in the last week and NOT modified in the last 3 hours.

    Would either of these possible please?

    Kind regards,



    Monday, September 1, 2014 1:21 PM

All replies

  • There is no way to do this by default as you are unable to use advanced find to filter on hours, minutes and seconds. All though these are defined in the date-time format.

    To accomplish this you would need to make a custom developed list.

    I cant even see you completing this request with any other semi-default functionality. I have tried thinking the cases through if you extract the HH from the date-time info, and that would work, but you would be missing the information on  your current date-time, which wouldnt allow you to search for values that are greater than 4 hours difference.

    So.. custom development unfortunetly.

    Rune Daub Senior Consultant - Dynateam CRM http://www.dynateam.dk

    • Proposed as answer by RuneDaub Tuesday, September 2, 2014 2:42 PM
    Tuesday, September 2, 2014 2:42 PM
  • You could always vote for this item on Connect in the vain hope that MS might actually add to the date/time filtering capability for "Older than X minute / hours / days / weeks"


    Hope this helps.
    Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
    UK CRM Guru Blog

    Saturday, September 6, 2014 3:25 PM
  • Unfortunately as the others have said, there is currently no way to do it through advanced find. My suggestion would be to create a report to look for records created in the last four hours.


    Wednesday, September 10, 2014 3:25 PM
  • This has been announced as an enhancement in the CRM 2015 Spring release (online only), which will then be rolled into later releases / service packs for on premises too. You can do older than X hours, days, months (and others).

    Hope this helps.
    Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
    UK CRM Guru Blog

    • Proposed as answer by Adam Vero Monday, April 13, 2015 11:24 AM
    Monday, April 13, 2015 11:24 AM
  • You might be able to handle this with a workflow (with a wait condition) and some flag fields, that indicate when/if the record has been updated.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Monday, April 13, 2015 4:23 PM