Add Last/This Fiscal Year as Criteria in Query

Currently when building a Query in NXT the only options for a changing date range is This Calendar Year and Last Calendar Year. More often than not, we are doing reports on fiscal years, not calendar years. Please make an option for This Fiscal Year and Last Fiscal Year in Gift Date ranges across all of the different date ranges (first gift, last gift, summary, gift)

  • Diana Bronsema
  • Apr 23 2025
  • Reviewed: Voting Open
Reporting and Analysis
  • Attach files
  • JoAnne Hendricks commented
    15 Oct 21:04

    We both of these use this ALL the time! Please add for queries and reports to avoid data mistakes and added manipulation of parameters.

    Attachments Open full size
  • Hillary Cote commented
    08 Jul 17:48

    This would be very helpful - we currently have to update queries and reports annually, when having a set parameter in our dynamic queries would just allow some reports and processes to run.
    We are working with a Blackbaud partner to set up an integration, and this question came up - seamless integration, but we have to update our queries annually, because we are missing "Fiscal Year" as a query criteria option.

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

    This would be so nice for queries and exports we use regularly. It would be nice to not have to update date ranges on all criteria every time the query or export is pulled.

    Attachments Open full size
  • Michelle Maye commented
    20 May 17:46

    so many things that are in DBV not in WV - this doesn't make sense, i thought this was supposed to be a more robust system?

    Attachments Open full size
  • Teddi Taylor commented
    09 May 16:58

    I would also like a Fiscal Year to Date <select date> filter!

    Attachments Open full size

Related ideas