Advanced Search

[JGM22]

Thx, unfortunately I need the Sunday day to never change as the start date. Changing the dates is not a deal break. Much appreciated.

[quant]

Maybe I don't understand.

Sunday day would never change, it would be the same for exactly one of your created searches that matches todays day.

If you create "Wednesday" search, it will be correct each wednesday. Creating 7 searches, and you are done, no need to mess up and manually update dates ever ;-)

[JGM22]

Quant -

In one of your replies I noticed the start date changed from 10/14 to 10/15. Would that not make the start date now a Monday?

I am needing the starting date ( Sunday ) to always be a Sunday and the ending date to always be a Saturday.

Basically whatever items I report on that the current week ( Sunday thru Saturday ) is what I am looking for. Then when next week begins it will reset to next Sunday thru next Saturday automatically.

I created the search like you suggested and clicked Store dates relative to current date. Problem is I do not want a rolling 4 days, it needs to be fixed.

Sunday search shows Sunday results
Mondays search shows Sunday and Monday results
Tuesday search shows Sunday, Monday and Tuesday results.
...
Saturday search shows Sun, Mon, Tue, Wed, Thu, Fri, Sat results.

Then the next week begins with Sunday and only things I close starting the next Sunday will show up on the search.

[quant]

"In one of your replies I noticed the start date changed from 10/14 to 10/15. Would that not make the start date now a Monday?"

- yes it would change tomorrow (it will be Thursday tomorrow), but you don't care because the search item is called "Wednesday", so you use it for your purposes only on wednesdays, on any other day it wouldn't do what you want. So when next wednesday comes and you click on this item it will do exactly what you want, because the start date will be 10/21, exactly what you need.

So all that's necessary is to create such search item for each day of the week and you are done for good. You canno't achieve what you want with a single search item, you need 7 of them, and use the correct one on a given day!

[JGM22]

Quant - Thx for the time and explanation, most appreciated. I have created the 7 days of searches and will try them out, thank you again.

It would be a whole lot easier if there were variables we could use such as @today, @tomorrow, @yesterday, etc.