I'm looking to write a script that shows me all the 'issues' where the date field is 7 days before today and 7 days after today.
I have the two below scripts, but I need one that integrates both of them;
Everything 7 days from today
"Start Date" <= endOfDay(7d) and "Start Date" >= startOfDay()
Everything 7 days before today
"Start Date" >= startOfDay(-7d)
Don't you just want to OR the two clauses together, ie
("Start Date"
<= endOfDay(7d)
and
"Start Date"
>= startOfDay()) OR
"Change Start"
>= startOfDay(-7d)
Although, changing your script slightly seems to work
"Start Date" <= endOfDay(7d) AND "Start Date" >= startOfDay() OR "Start Date" >= startOfDay(-7d) AND "Start Date" <= startOfDay()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunaly not as the first one will give me all the issues 7 days from today and then EVERYTHING before today, and then the second one gives me all the issues from 7 days before today and then EVERYTHING after today. So putting them both together basically gives me EVERYTHING :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.