Add a date range that is by number of days or months or years

At my organization we are working on creating dynamic reports with rolling dates. Particularly looking at revenue information over a rolling 12 month period. There are options in the date range dropdown of Last Calendar Year, This Calendar Year, YTD, Fiscal Year.. but there is no way to specify that the Query should pull data based on less than or equal to 12 months or something like that. This would be very helpful.

  • Diana Bronsema
  • Mar 20 2025
  • Reviewed: Voting Open
Reporting and Analysis
  • Attach files
  • Guest commented
    22 Sep 13:40

    Yes, need to be able to query/list based on, eg the last 30 days from today, not last month which could be either 1 day ago or 25 days ago. Rolling "specific" dates for queries and lists please! :)

    Attachments Open full size
  • Mark Palfrey commented
    05 Sep 06:33

    This would be a game changer for us also! Blackbaud Direct Marketing used to have this and I am sure Blackbaud CRM will also. Makes sense for this to be available in RENXT also.

    Attachments Open full size
  • Guest commented
    29 May 20:30

    YES!!!!!

    Attachments Open full size
  • Alice Tisdale commented
    28 May 20:15

    This would be a game-changer. My org uses queries for email lists that need to be updated monthly with recent giving information in a certain time frame (usually the last 12 months.) Which means every date range on every set of criteria and every giving total in the export, needs to be updated every time the query is run. A rolling date range option would change this whole reporting process to a "set it and forget it" kind of operation!

    Attachments Open full size

Related ideas