are you able to write the code for your two selections?
if you can do this try the following.
click on a list box containing your dates. Click on search or just start typing. Make sure your search query begins with the equal sign "=" followed by the code for your select. You will know if it is working because the corrcet dates will be selected.
Save this as your bookmark.
Qv will store your search query in the boomark and not the dimesnion elements this returns. thus making your bookmark dynamic.
To check this open a current selections object and select your bookmark.
My formula should be something like this :
=<today()-1 > today()-8
However, even the function = today() selects too much data. I would expect the system to select only today's date in this case but it doesn't. I want to select all the dates between yesterday and 7 days before yesterday by means of a dynamic select.
try something like this in the search box, replace "Timestamp" with the name of your date field
=if(floor(Timestamp)>floor(today(2)-8) and floor(Timestamp)<floor(today(2)) ,1)
the parameter 2 inside the today() function means it will take the time teh document was opened so it shouldn(t be constantly evaluating itself.
another alternative is to set a vraible i your script - especailly if the data is getting reloaded everyday.
the floor() functions get around problems caused by formatting and the bits of days you get in timestamps.