Please Add the Ability to Query for a Date Criteria 'One Year Ago Today'

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. 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
  • Attach files