How do I use advanced find to find records older than 7 days? RRS feed

  • Question

  • Dynamics 2011, update 8 on premise

    Has anyone found a way to utilize Advanced Find to search for records that have not been modified in the last x number of days or weeks? I can't seem to find the "Modified On" -> "Older than x Days or Weeks" option.

    PS I can't specify dates.  It needs to be dynamic.


    Scott Clancy

    Monday, September 24, 2012 9:32 PM

All replies

  • You might have to do something like make a Marketing List with all Accounts and the remove members from the list with an Advanced Find - and the criteria would be those accounts that have been modified in the Last X Days. 

    Of course this really isn't re-usable. 

    Jason Lattimer

    Monday, September 24, 2012 9:47 PM
  • Thanks Jason, I saw someone post this soultion in the past.  Unfortunately that's not going to be do able solution.  We need views liks this on non account records and we don't use marketing lists.  This seems like a VERY basic query request.  Is there something more elegant than a marketing list?


    Scott Clancy

    Monday, September 24, 2012 9:53 PM
  • I don't think there is - the Advanced Find has the one big limitation that you can't use the "not" operator. It appears the query would work using the "Older Than" selection, but months appears to be the only out of the box option for some reason. 

    Obviously a SQL Report could also get you the data but still wouldn't fit your requirements. 

    Jason Lattimer

    Tuesday, September 25, 2012 3:18 AM
  • Wow I find it hard to believe it's not supported.  Going the SSRS route is a high tax for this and it's not a flexible one either.

    Scott Clancy

    Tuesday, September 25, 2012 11:15 PM
  • Hi Ken, I don't have access to the Connect site but 'm glad others are asking for this.

    Scott Clancy

    Thursday, October 4, 2012 7:18 PM