Altru 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