Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks

    Scott Clancy

    Monday, September 24, 2012 9:32 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Scott Clancy

    Monday, September 24, 2012 9:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Join the club :)

    https://connect.microsoft.com/dynamicssuggestions/feedback/details/678568/allow-not-in-searches-in-advanced-find-marketing-lists-etc

    Thursday, October 4, 2012 7:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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