Hi Tamara,
I've seen this question asked a few times, and we have the same requirement ourselves, but to my knowledge, this requirement to create a dynamic relative selection is currently not offered. I would check the Idea Place and if you can't find such a suggested improvement, add it!
The closest possible option is to "Save Time Characteristics as Relative" when saving a Report Selection. This functionality works as follows:
When creating the Selection, you enter a fixed date/date range, check the "Save Time Characteristics as Relative" checkbox, and save. Then, whenever the report is opened, C4C calculates the offset from the date the Selection was created to today's date and adjusts the range accordingly.
So for your case "older than two weeks," you could create a date range of Jan. 1 2000 --> Today and save as relative. Then when you open the report in one month, the selection instead will be Feb. 1 2000 --> Today. It's not a perfect solution, but it's the best workaround I know.
As a final note, the reason I bolded the points about creation of the Selection is that the "Time Relative" calculation always takes the Selection creation date not Changed On date. So, if you mistakenly enter the wrong date range to start, you need to delete the selection entirely and create a new one.
Hopefully someone can prove me wrong, as I would like this functionality as well, but if not, I hope the workaround is helpful.
Best Regards,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.