Altru Ideas

We value your unique insight into our products and services and often receive ideas and feedback from our community in a variety of ways. To streamline this process, we’ve created an idea bank where you can post product suggestions, vote for those most important to you, and add comments to existing ideas.

Expand Date Range Options in Query

I am frequently running and rerunning queries where I want to capture items from the last 3, 6 or 12 months. Using "last quarter" or "this calendar year" doesn't work. Needing to pick a specific date and update it every time I run my reports leaves room for error. 

I would love to be able to select an option for N days, weeks, months, quarters, or years and then pick how ever many I'd like to include.  This way my query would always be accurate with relative dates.

I've seen this option in some of the smart fields. I am hopeful we can expand it to queries as well.
  • Guest
  • Jan 4 2016
  • Reviewed
  • Attach files
  • Margaret Matteson commented
    August 23, 2018 15:14

    In addition to more relative dates, we really need Last YTD in addition to this YTD. 

  • +10