I would like to use a Query in quick search to show a rolling two week list of stories. IS this the right syntax - "Stage Date" >= endOfWeek(2)
It depends on what "stage date" is for, but we do not really need to know that to explain the behaviour of the functions.
I am not sure endOfWeek() is going to do what you want. endofWeek(2) might be between 8 and 15 days away from now.
Imagine that it is Wednesday of week 12 of the year today. endofweek(2) here means midnight a week on Saturday, which is 10 days, not a fortnight.
If you want a simple rolling date (two weeks is the Wednesday after next, but when I get up tomorrow on Thursday, it's the thursday after next), use a simple "date >= +14d"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.