AnsweredAssumed Answered

Complex ways of filtering by date, Advanced reporting

Question asked by KarolKonofal82343391 on Oct 20, 2017
Latest reply on Oct 26, 2017 by Deepak.Bhadri.1

Hi Community members,
Does anyone of you know how we can set date filter in Advanced reporting so that whenever the raport is to be generated it should show time entries of previous week and only previous week?
It's easy to set fixed date range by using 'Date Worked', and 'is equal' 'is between' values but what I would like to do is to have a certain report send out each Wednesday to a certain group of people that should contain values of previous week time entries.
I did the filters as below but thats not exactly what I want. Here raport will simply gather the data from each period before current week but not older than this month's week. So assuming I'll leave it like that it'd gather data from first week Mon-Sunday, and send it out on Wendsday of the second week. Further it'd gather the data from Mon-Sunday first week AND Mon-Sunday second week and send the data out Wendsday of the week third.
What I want is to have all weeks send out separatelly. How could I do that?
The questions is not about the job scheduling as I know how to set it, it's the date range I'm struggling with.

 

 

Outcomes