Need More Date Choices
We need additional ‘special date’ choices in Ad Hoc Query. We would like a way to define our own additional ‘special date’ choices. For example, we need Fiscal Year, Fiscal Year-1, Fiscal Year-2-5, Calendar Year-2 thru 10, First Quarter, 2nd Quarter, 3rd Quarter, 4th Quarter, etc. These are just a few examples of the ‘special dates’ we need. Currently, every time I run a query for the next time period, I will have to manually change the specific dates that I've entered. I will have to manually change OVER 800 selections/segments to have the next time period’s dates for some of our mailings!
I have already upvoted, but thought I would add that in our organization we have 100's of queries that rely on fiscal year date ranges. At the flip of every fiscal year, my team and I manually update all of these queries. Having additional fiscal year-based relative date objects like the ones outlined in the OP would save us ~50 man hours every year.
Attachments Open full size
At a minimum, it would be really helpful to have the same fiscal year date choices available like we do for calendar year (Fiscal Year to date, Last Fiscal Year, This Fiscal Year, etc.).
Attachments Open full size
We would love to have the new relative dates available for queries over the transactional database.
Attachments Open full size