Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit CRM-I-257 Rolling date-range in query filtering.

Rolling Dates - Please Add the Ability to Query for a Date Criteria 'One Year Ago Today' to the standard query tool Merged

In a query, when applying criteria to a date field, the dropdown allows you to specify This week, This month, this Quarter, This Calendar Year,etc.. However, it would be extremely helpful if you could query by one year ago today. (Or X years ago from today, X months ago from today, X days ago, etc.) An example would be to query for all pledges to last year's annual campaign with a pledge date on or before the same date that the query is running, one year ago today. We are unable to use data warehouse functionality, so we are asking for this ability to appear in standard CRM querying.

  • Jon Herz-Midler
  • May 9 2019
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Jewish Federation of Sarasota-Manatee
Reported Version 4.0