Add a date offset option to Query

Query currently allows us to select records where a date is After Tomorrow or Before Yesterday, but for some of our most critical business processes, e.g., building supporter journeys, we need to be able to select records where a date is Before Today minus 3 days (or similar).  Please extend Query to allow an offset (positive or negative) to Today.  It could work by having an option 'Days offset' which would show up when we chose Today in the list of dates.

  • Guest
  • Apr 20 2016
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) The Wilderness Society Ltd (Australia)
Reported Version 4.0
  • Attach files
  • Guest commented
    July 21, 2016 02:29

    This is similar to the 'rolling date' option which is apparently available for queries on the data warehouse, but we would very much like it for all queries.  We shouldn't have to buy the data warehouse just so we can query on dates like this.


    Please extend the rolling date functionality to all queries.

  • Guest commented
    July 21, 2016 02:37

    P.S. I'm David Wanless.  I don't know why it's recording me as 'Guest'.

  • Ineke Clewer commented
    July 21, 2016 14:09

    I definitely agree - we often want to do a rolling year and there's no way to do this, but with this idea we could do on or after minus 365 days

  • Lucy Jones commented
    March 16, 2017 01:24

    I think rolling dates in query should really be available without data warehouse. The current options are far too limited to be of much use for most of our needs. I imagine many other organisations are finding this too.

  • Guest commented
    April 04, 2018 19:43

    Make rolling date available in OLTP as well!

  • David Bourne commented
    May 03, 2019 02:10

    We've actually solved this one with a custom query node that supplies relative dates to any other table. If you are interested feel free to contact us. David Bourne - The Wilderness Society (Australia)