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.
-
David Wanless
- Apr 20 2016
- Reviewed: Voting Open
| Organization Name (Please enter full organization name) | The Wilderness Society Ltd (Australia) |
| Reported Version | 4.0 |
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +1
Related ideas
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)
Make rolling date available in OLTP as well!
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.
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
P.S. I'm David Wanless. I don't know why it's recording me as 'Guest'.
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.